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" <[email protected]> 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 > [email protected] > > -- > http://www.fastmail.fm - One of many happy users: > http://www.fastmail.fm/docs/quotes.html > > -- dave boland [email protected] -- http://www.fastmail.fm - A fast, anti-spam email service. -- 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
