"The Same Parent cannot be parent for 2 child tables" - Why the ****
NOT?!!!

I have a table with User ID, Division code field.

When I try and run the query wizard to select the User name and
division name from 2 other tables, using the fields as look ups into
those tables, I get the above error message.

Obviously, it's no problem doing this with SET RELATION, why should it
be a problem in SQL?

Is this a SQL limitation? A Wizard bug? Is there actually a good
reason why this isn't allowed? I'm coding around it for now, but this
is annoying. Any suggestions? (Other than telling me to lay off the
coffee....)

Ignore munged e-mail address above.
If necessary to reply via e-mail, please reply to:
caracal A T caracal D O T net