Dustin Stanley
asked on
Ms Access Many To Many Relationship Explantion Help Please
I have two tables
SKUs
SkuRestrictions
I now have it set up as a one to many. As in SkuRestrictions can have many SKUs
It has worked great until now.
SkuRestrictions is a table with restrictions. Examples: Freight Shipping , No Free Shipping , Medical Disclosure and so on.
SKUs are products. Today I thought sometimes a SKU may have many Restrictions.
I know the proper way is to make another table as the junction table. But can someone help me on this part. The junction table is supposed to also include other fields that are specific to that SKU and SkuRestrictions value.
What fields might I put here? I'm just drawing a blank. I guess I could just not put anything else but that seems crazy.
Thanks!
SKUs
SkuRestrictions
I now have it set up as a one to many. As in SkuRestrictions can have many SKUs
It has worked great until now.
SkuRestrictions is a table with restrictions. Examples: Freight Shipping , No Free Shipping , Medical Disclosure and so on.
SKUs are products. Today I thought sometimes a SKU may have many Restrictions.
I know the proper way is to make another table as the junction table. But can someone help me on this part. The junction table is supposed to also include other fields that are specific to that SKU and SkuRestrictions value.
What fields might I put here? I'm just drawing a blank. I guess I could just not put anything else but that seems crazy.
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PatHartman
That's a good article. Most don't even mention that you need a composite PK or Unique Index on a junction table.
ASKER
I thank you for the help. The unique index is helpful and I am glad to know all junction tables do not have to include specific data. Sometimes at the time it doesn't seem like there will be any specific data but as time passes it does come up. Thanks.