Hi Walter, Peter
Actually yes you can have a column in a table invlolved in multiple
relationships. These relationships can be between just two tables, if
you like.
It is true however that you can not use the Relationship window to set
this up. In fact there is an issue covering this, Issue #56898
<http://qa.openoffice.org/issues/show_bug.cgi?id=56898>. The defect is
with the GUI, not the database engine used. Meaning that you must use
alter table commands to set this type of multiple relationship up.
There is also athread at
http://www.oooforum.org/forum/viewtopic.phtml?t=21632 with an example of
exactly how to do this.
HTH
Drew
Walter A. March wrote:
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]
