One to Many relationship

Hello - How can I set up a one-to-many relationship? For example I have the
following 2 files and layouts:

member_id product_id
1 A
2 B
3 B
4 A
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13709-one-to-many-relationship.html
5 C

product_id product_desc
A software
B hardware
C accessories
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13709

So the second table would be the "one" and the first table would be the
"many". I've seen this in the relationship window, where there will be a "1"
and an infinity symbol printed on either side of the line that connets the 2
tables.

Thanks,
Dave




--
Regards,
Dave

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

"David Billigmeier" wrote in message
news:F040713F-9F2E-4637-AC62-97D1B3ED79E5@microsoft.com
> Hello - How can I set up a one-to-many relationship? For example I
> have the following 2 files and layouts:
>
> member_id product_id
> 1 A
> 2 B
> 3 B
> 4 A
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13709
> 5 C
>
> product_id product_desc
> A software
> B hardware
> C accessories
>
> So the second table would be the "one" and the first table would be
> the "many". I've seen this in the relationship window, where there
> will be a "1" and an infinity symbol printed on either side of the
> line that connets the 2 tables.

Let me know if this simple answer isn't what you're looking for.

1. Make Sure that product_id is the primary key of the table of
products.

2. Open the Relationships window.

3. Add both tables to the Relationships window, if they aren't already
there.

4. In the Relationships window, drag the product_id from the products
table and drop it on the product_id in the other table.

5. This will open the Edit Relationships dialog, to specify the
properties of the relationship between these two tables/fields. It
should show the relationship type as One-to-Many, in the direction you
want it.

6. To cause the relationship to be enforced, which you probably want to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13709
do, check the box "Enforce Referential Integrity". You may or may not
want to check the subordinate boxes about cascading updates and deletes.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Hi Dirk -
Thanks for the response. I do that, however it always says "Intermediate"
for relationship type, and I can't seem to manually change it over to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13709
"One-to-Many".


--
Regards,
Dave


"Dirk Goldgar" wrote:

> "David Billigmeier" wrote in message
> news:F040713F-9F2E-4637-AC62-97D1B3ED79E5@microsoft.com
> > Hello - How can I set up a one-to-many relationship? For example I
> > have the following 2 files and layouts:
> >
> > member_id product_id
> > 1 A
> > 2 B
> > 3 B
> > 4 A
> > 5 C
> >
> > product_id product_desc
> > A software
> > B hardware
> > C accessories
> >
> > So the second table would be the "one" and the first table would be
> > the "many". I've seen this in the relationship window, where there
> > will be a "1" and an infinity symbol printed on either side of the
> > line that connets the 2 tables.
>
> Let me know if this simple answer isn't what you're looking for.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13709
>
> 1. Make Sure that product_id is the primary key of the table of
> products.
>
> 2. Open the Relationships window.
>
> 3. Add both tables to the Relationships window, if they aren't already
> there.
>
> 4. In the Relationships window, drag the product_id from the products
> table and drop it on the product_id in the other table.
>
> 5. This will open the Edit Relationships dialog, to specify the
> properties of the relationship between these two tables/fields. It
> should show the relationship type as One-to-Many, in the direction you
> want it.
>
> 6. To cause the relationship to be enforced, which you probably want to
> do, check the box "Enforce Referential Integrity". You may or may not
> want to check the subordinate boxes about cascading updates and deletes.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>

"David Billigmeier" wrote in message
news:2BAC13BC-CB4B-41C8-B874-E662EEA0FBEB@microsoft.com
> Hi Dirk -
> Thanks for the response. I do that, however it always says
> "Intermediate" for relationship type, and I can't seem to manually
> change it over to "One-to-Many".
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13709
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13709

Maybe you have a unique index set on the foreign key "product_id" in the
other table. Make sure the field is either un-indexed, or has its
Indexed property set to "Yes (Duplicates OK)".

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)