Peter Humphrey wrote:
Hello all,
I'm trying to set up a database to represent a sort of social club, which
has various organisational units like districts, each with several
officers. I want those officers to be represented in the Districts table by
references to the People table, but I can't see how to set this up. I can
create one relationship between the two tables, but I think that isn't what
I need. Can someone point me to where I can find out?
In case it matters, I'm running OOo on Gentoo Linux.
Let me restate the question so I make sure I'm at least close.
we have a person table that has an id field and a name field (as a minimum)
also a districts table with, say, president, vice president, etc.
I don't think you can relate the person table to the districts table
more than once. You can't edit the relationship to use the person Id
field more than once and you can't add the person table to the
relationship window more than once.
I would think three tables instead. Districts have people (but no office
field) and people have offices. The offices table would have an id and
an office name.
WalterAM
(I copied [EMAIL PROTECTED] to confirm my tests of the relationship window)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
