Auto populate Access DB field

[fsupport1600]

I have created 3 tables:

Table1: Room Information
- RoomName
- RoomNumber

Table2: Product Information
- Tag ID
- ProductName
- ProductMake
- ProductModel

Table3: Quanity information
- RoomNumber (Relationship)
- Tag ID
- ProductName
- ProductMake
- ProductModel

In table 3, how do I get the ProductName, ProductMake, ProductModel, to autofill based on the Tag ID selected which is part of Table2?

 

[BlueHorizon]

Why not create just one table with Product and Quantity information?

Best,
Blue Horizon

 

[dhookom]

Typically you would not want the ProductName, ProductMake, and ProductModel stored in more than one table. Assuming Tag ID is the primary key in Table2, you can always join to Table2 to display these field values.

Duane
Hook'D on Access
MS Access MVP