How do I link a text box to a column on a table?

[airhendrix13]

Hi,

I am trying to make an asset management database. Currently I have several tables already set up that I would like to be organized into a form. Basically what I have in mind is a switchboard (already setup) that has the equipment type (balances, centrifuges, etc..) that when I click on one of the equipment types will open another switchboard that will have manufacturers (EMD, Advent, etc...) and when I click on a manufacturer will open a list of models. Finally when I click on a model I need it show all the information for that model.

So here is what I have in mind for that. For each column in my table I need a text box that will pull that info from that cell.

I also need to be able to add new items using a form and have it automatically know where to put the info on the table.

Any Ideas?

Thanks

 

[mhartman]

Hello:

The below article shows how to create a "Look-Up" table.

http://support.microsoft.com/kb/311173/en-us

Regards
Mark