Re: Indeterminate relationships in Relationships Window
From: Graham Bellamy <dontwriteme_at_ask.first.com>
Date: Fri, 26 Jul 2002 03:09:46 +1000
Message-ID: <ahpbdg$9o9$1_at_perki.connect.com.au>
> "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 - 19:09:46 CEST
Date: Fri, 26 Jul 2002 03:09:46 +1000
Message-ID: <ahpbdg$9o9$1_at_perki.connect.com.au>
"Pieter Linden" <pietlinden_at_hotmail.com> wrote in message
news:bf31e41b.0207241706.5cfe9a67_at_posting.google.com...
> "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 - 19:09:46 CEST