One to Many relationship

[Guest]

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.

Thanks,
Dave

 

[Dirk Goldgar]

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.

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.

 

[Guest]

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".

 

[Dirk Goldgar]

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".

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)".