Problem with many to many relationship

[gudiya]

I have a database with product table(Product_ID as
pk,Product_Name),location table(Location_ID as PK,Location_quantity)
,junction table(Product_ID as fk,location_ID as fk and Relation_ID as
pk),Transaction table(Transaction_ID as pk and linked to product table
with fk,Product_Quantity)

I have already defined many to many relationship.But how must i display
it on form for editing,adding.How should I design the query to know the
which product is stored in which location and check to see that sum of
location_quantity for each product should be equal to Product_Quantity
in transaction table for that product.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImplementingM2MRelationship.mdb" which illustrates a couple
of ways to do this depending on your business rules.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L