Re: [libreoffice-users] Re: Base scenario

> I have the following -
> A Members Table called 'Members' with ....
>
>   * The Key being 'RecordID'. INT, Auto,
>   * Plus the rest of my 70-odd fields..........  (This table comes up
> in my "Main Form")

70 fields in one table? Sounds like this database may be de-normalised:

http://en.wikipedia.org/wiki/Database_normalization
 
> I have now added another table called 'eMail' which has .....
>
>   *   The Key being 'MessageID', INT, Auto
>   *   Plus the rest of the fields for Date, Type, Title and Message.
>     (All TXT)
>   *   The final Field is called 'MembersID', INT, NOT Auto,

> You mention a "Foreign Key' which maybe the answer to what I'm trying
> to do but how do I declare the RecordID/MembersID Relationship?

http://en.wikipedia.org/wiki/Foreign_key

The Libreoffice Base handbook hasn't been entirely translated yet:

https://wiki.documentfoundation.org/images/b/bb/BG3401-IntroducingBase.pdf
https://wiki.documentfoundation.org/images/6/65/PlanningDesigningYourDatabase_DEL_20120809.odt
https://wiki.documentfoundation.org/images/0/06/Data_input_and_removal_DEL_20121106.odt

Sincerely,

Wolfgang

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted