Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.