[libreoffice-users] Relational database example help

I have been messing around with Base for a relational application.  The
User Guide mentions the word "relational" twice, but offers no
examples/explanations.  That really needs to be changed.

In the mean time, perhaps someone could write up a quick procedure for
the simple example I have below.  My interest is mainly setting up the
tables (4) and making sure the company name is in both the Client and
Contact tables.  I realize that a foreign key comes in to play, but it
is not clear how to do this or how information flows from one table to
another.  The forms seem to be easy, so they were included just to
complete the thought.

The example application a customer information database.  It uses forms
for input, reports with queries.

The information collected is:
[Company]
Company ID.........Int.......Primary Key
Company Name.......VarChar...Name
Company Address....VarChar...Address
Company URL........VarChar...URL

[Client]
Client ID..........Int.......Primary Key
Company Name.......VarChar...Same as Company.Company Name
Client Name........VarChar...Individual's name
Client Department..VarChar...Department the client works in
Client Phone.......VarChar...Phone number
Client Email.......VarChar...e-mail address
Client Interests...VarChar...Interests
Client Notes.......Memo......Information about client

[Contacts]
Contact ID.........Int.......Primary Key
Contact Date.......Date......When I contacted the client
Company Name.......VarChar...Same as Company.Company Name
Client Name........VarChar...Same as Client.Client Name
Contact Method.....VarChar...From a list that includes phone, e-mail,
meeting, FAX
Contact Notes......Memo......Notes/ToDo for the client
Followup Date......Date......The date that I need to re-contact the
client.

There will be three forms - Selection, Client Information, and a
sub-form for Company Information.  They may look something like this:

-----------------------------------------------------------------------------------------
~~~ Selection ~~~
#   Company Name     Client Name
--  ---------------  ------------
1
2
:
nth

[Go To Client]  [Add Client]
-----------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------
~~~ Client Information ~~~
Company Name [Company Information Link]:  
Client Name:                             Client Department:
Phone:                                   e-mail:
Interests:
Notes:

           Contacts
#   Date    Contact     Method   Notes                      Follow-up
Date
--  ------  ----------  -------- ------------------------- 
--------------
1
2
:
nth

[Add Contact]  [Update Contact]

-----------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------
~~~ Company Information ~~~
Company Name:
Company Address:
Comapny URL:

[Add Company]
------------------------------------------------------------------------------------------



Thanks,
Dave
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - One of many happy users:
  http://www.fastmail.fm/docs/quotes.html


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