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. -- Rgds Peter --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
