Good morning. I'm new to this list, and thought it polite to introduce
myself before I ask for help. So . . .
My professional career is one which has travelled a long and winding
road. I began my university career studying aerospace engineering before
deciding to become a parish pastor in United Methodist and Presbyterian
congregations, where I served for about 27 years. Then I apprenticed and
worked as a baker of bread for 6 years. Now, I am the co-Founding Pastor
of a new church development (which will combine ministry and baking --
it's a story I'm happy to share, but one which is likely not germane to
this email).
When I was in parish ministry, my wife and I used Lotus SmartSuite,
including its relational database, Approach. I believe I was fairly
proficient at it for the needs I had. But it's been 6 years of so, which
means my skills are rather rusty -- and we've switched to LibreOffice,
which means that some things are done in a slightly different manner.
And I've found I need some help.
I am creating a relational database of our friends and followers. The
first table I created was one called "Connections," because it is a
"master table" keeping track of all the folk with whom we make some sort
of connection. As you might guess, the fields (is that the terminology
used nowadays?) include a CID (connection ID), which is an
auto-incremented ID number field and the primary key, first and last
name, address and other contact fields, etc.
I am now creating a second table to record the information about
contacts we had with our connections during a particular fundraising
event. My thought on the design of this table is that it would have the
connection's CID, name, and the amount they donated. I figured that I'd
again make the CID the primary key for this table, and create a
relationship between those fields in the two tables. I would also like
it set up so that I can enter the name in the event table and the rest
of the information will be pulled in from the other table.
I created the new table and linked the two CID fields. But when I enter
the name in the event table, it doesn't automatically pull up the
information from the other table.
Any help would be greatly appreciate.
Doug
--
To unsubscribe 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
