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: users+unsubscribe@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