Re: [libreoffice-users] Re: Relational database example help

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"
<alex.thurgood@gmail.com> 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: 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
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - Same, same, but different...


-- 
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