Peter Humphrey wrote:
On Wednesday 06 September 2006 00:58, Walter A. March wrote:
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.
Hmm. Sounds like a separate table for each named office that can exist,
which means a couple of dozen at least, to allow, say, three committee
members at each level of the organisation. Let me think about that -
thanks.
Would a compound form help me? I.e. a form built on the Districts table with
sub-forms pointing to the people? Or perhaps I'd run into the same
limitation.
I was expecting to find a way to define, say, a field in the Districts table
as a pointer to a record in the People table, but if that's possible it's
hiding well.
Thanks again.
As so often happens on this list, after I hit send I said Ah... what if
one person held two offices or, as you mentioned, multiple people held
one office.
Luckily, Drew Jensen came through with an answer on [EMAIL PROTECTED]
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
As far as defining a field as a pointer between tables, that's what the
relationship would be. Drew's (and mine sort of) answer is that you
can't have multiple relationships between a table through the graphical
Relationships tool.
Take a look at the thread Drew provided.
http://www.oooforum.org/forum/viewtopic.phtml?t=21632
I will tonight if I get a chance.
Thanks Drew!
WalterAM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
