I have an inventory database. Items have 1 or more locations in the warehouse. Each location houses 1 to 8 items. I will need to enter multiple locations for ind items and query the locations for each item and query items in each location. Is the relationship btw the item table and the location table one to many or many to many? I think it is one to many as I have stated the listing of locations for an item is a query and the listin of items for each location is a query.

---

Reply from Alex Hedley:

Tip
Expert 1
Access Relationship Seminar