Re: Indeterminate relationships in Relationships Window

"Graham Bellamy" <dontwriteme_at_ask.first.com> wrote in message news:<ahmst7$dcq$1_at_perki.connect.com.au>...
> What is the purpose of indeterminate relationships created in the Relationships window?
>
> TIA
> Graham
Graham,
I think "purpose" is the wrong word. What it means is that Access can't figure out from examining the fields used in the join which table is supposed to be the parent (the "one" side) and which is supposed to be the child (the "many" side). About the only way I can think of causing this is by:
1. no unique index on the parent table.
2. not joining the tables on a unique index on the parent side.

So slap a primary key in your parent table and try it again. Make sure the FK in your child table is of the same type. (If you're using an autonumber in tblParent, use a Long as the FK in tblChild) HTH,
Ither Received on Thu Jul 25 2002 - 03:06:28 CEST