Create a lookup field

[timmyjc18]

i am new to access. I am creating a database that has one table with 4 fields labeled: Barcode, Description, Product ID and Size. I want to create a new table that when I type or scan in a barcode, fields next to it will populate with the Description, Product ID and Size automatically. How can this be done? I have attached a sample. Thanks

[June7]

First, create the new table.

Second, build relationships between the tables or build forms to interact with data or do both.

Third, if using forms, build combobox on form with a RowSource from table 1.

This is all basic Access functionality and Access has guidelines and tutorials are available on web and books from stores.

Review
http://forums.aspfree.com/microsoft-...es-208217.html
http://www.developerbarn.com/communi...-database.435/