Thanks Alex. I was unaware of form binding. This may be a great answer for this situation.
Dave, On Monday, September 26, 2011 7:29 PM, "Alexander Thurgood" <[email protected]> wrote: > 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 > -- dave boland [email protected] -- http://www.fastmail.fm - Same, same, but different... -- 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
