> 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: http://wiki.documentfoundation.org/images/b/bb/BG3401-IntroducingBase.pdf http://wiki.documentfoundation.org/images/6/65/PlanningDesigningYourDatabase_DEL_20120809.odt http://wiki.documentfoundation.org/images/0/06/Data_input_and_removal_DEL_20121106.odt Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@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
