select and insert using two seperate tables

[benjammin]

OK, this might be redundant, hopefully. Simply inventory database I'm working on.

Tables:


tblEquipmentModels (where everything is written)
tblEquipmentType (type of equipment)
tblVendors (vendor of the equipment)

I want to create a query and eventually a form that will let me Add/Edit/Delete equipment models. tblEquipmentType and tblVendors are related to tblEquipmentModels by an ID key.

In the tblEquipmentModels there are two columns, VendorID and EquipTypeID, each has a number relating to the ID in the two other tables.

How do I use the query to select and display the choices of vendors and equipment types and write their corresponding ID to the tblEquipmentModels fields?

Does this make sense? Attached is a screenshot incase it doesn't. THANKS!

[benjammin]

maybe this belongs in the forms section?

[orange]

Here are some links to great references and tutorials.
http://www.datapigtechnologies.com/AccessMain.htm free video tutorials
http://www.allenbrowne.com/casu-22.html Crystal's Access Basics
http://www.fontstuff.com/siteindex.htm#access Martin Green's Tips
http://www.databaseanswers.org/data_models/index.htm sample data models

Take a look at some of the Inventory models to get some ideas.

Inventories are not really all that simple.

Good luck.