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

Hi :)
Sorry for the delay!  We seem to be a little slow in the last couple of weeks.

The 2nd table probably needs it's own ID field (yes, it's the right
term) even though it's not really going to be used at all.  Is each
row in the 2nd table unique to a Contact?  or do some contacts have
more than 1 row in the 2nd table?

I suspect that the Event Table needs to be a Query rather than a
table.  Queries look a lot like tables.  It might need to be a Form
instead though and i would build Forms by basing them on Queries.  The
Query would pull the information from both tables together then the
Form might be what you need to be able to type a name into in order to
get the details of that row of the Query.

I'm kinda clutching at straws here but i think you need to check on 3 things
1.  Give the 2nd table it's own ID
2.  Check the type of relationship linking the Connections table to
the 2nd one (ie 1 to 1, 1 to many, or many to 1, (many to many seems
3.  Try using an external back-end to store your data tables rather
than the internal one built-in

How you do that 3rd thing is still a bit beyond me but there are tools
such as Postgresql, MySql/MariaDB, HsqlDB and many others.  I don't
know which is best but it probably depends on how large the tables are
likely to be.  For any kind of contacts database it's likely to be
reasonably small so you could aim for the small, light and fast ones.
Regards from
Tom :)

On 20 November 2013 15:56, Doug Essinger-Hileman
<> wrote:
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.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.