Le 26/09/11 16:14, dave boland a écrit : Hi Dave,
You will have to decide which form is going to be your main form, and then link the others to it via the relations you wish to create. So, for example : > The information collected is: > [Company] > Company ID.........Int.......Primary Key > Company Name.......VarChar...Name > Company Address....VarChar...Address > Company URL........VarChar...URL > You could link Company_ID to Company_Name in Client, Contacts and Selection as a foreign key of these tables. Then when you design your Client and Contacts form, bind the field Company_ID to the corresponding Company_ID in the Company table, and then indicate that what you want displayed in the form as the bound column is actually Company_Name. The sub-form wizard should enable you to do that (i.e. when creating Client form, go through the subform wizard steps to bind to the Company table as well, which in effect creates a subform within your main form). You could also set up Contacts as a subform of Clients in the same way, e.g. as a grid control. These are of course just suggestions, there are many ways to skin a cat :-)) Alex -- For unsubscribe instructions e-mail to: [email protected] 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
