I started a thread on the general users list, not having found this one. Now that I have, here's what was said:
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 -- Rgds Peter Humphrey --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
