By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Relate Tables

P: n/a
Hello,
I have two tables in access, Equipment table and inventory table
I need to relate the tables so that I can match every part in inventory
to a vehicle.
For example Vehicle 1-1-1 (Equipment table) uses a 1030 oil filter,
1624 fan belt, 1204A headlight all from (Inventory table).
I know I need to create a many to many table but not sure how to
accomplish this. Any advise on this design would be greatly appreciated.

Jan 11 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 10 Jan 2007 18:31:18 -0800, "alexus" <al****@pgtc.comwrote:

Check out the Northwind.mdb sample application. It has a M:M relation
between Orders (Equipment) and Products (Inventory) via OrderDetails
(your new table).
The Orders form is where the OrderDetails table is populated.

-Tom.

>Hello,
I have two tables in access, Equipment table and inventory table
I need to relate the tables so that I can match every part in inventory
to a vehicle.
For example Vehicle 1-1-1 (Equipment table) uses a 1030 oil filter,
1624 fan belt, 1204A headlight all from (Inventory table).
I know I need to create a many to many table but not sure how to
accomplish this. Any advise on this design would be greatly appreciated.
Jan 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.