[libreoffice-users] Re: Relational database example help

Looks like my net connection went out before this was posted, so this is
attempt 2.

Dave,

On Monday, September 26, 2011 10:14 AM, "dave boland"
<dboland9@fastmail.fm> wrote:
> 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
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - A fast, anti-spam email service.


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