Basic Look Up Fields

[racoester]

I am new at access and cannot figure out how to look up a value in a table from an existing table and populate multiple fields from the look up table into the exisitng table...and does it work the same way with a form?

 

[Jack Cowley]

The only thing you want to put in the table from the lookup table is the ID of the record you select otherwise you will have the same data in two places and that is not good.

If you want to add a person, for example, to a table you would use a combo box bound to the PersonID on a form that is bound to the table. The combo box would be based on the People table and would have their RecordID as the bound column in the combo box. If you use the Wizard to create the combo box it will do the work for you.... To get an idea of what I am talking about open the Northwind database that comes with Access and look at the "Employees" from and the "Reports To" control in particular...

hth,
Jack

 

[racoester]

Thank you very much....what if I want to bring multiple values over from the look up table and have them auto-populate when the key field from the look up table is selected?

 

[Mile-O]

Thank you very much....what if I want to bring multiple values over from the look up table and have them auto-populate when the key field from the look up table is selected?

Select them into the combobox too but hide the columns.

When necessary, reference the appropriate column

i.e

MyCombo.Column(2)

 

[Pat Hartman]

what if I want to bring multiple values over from the look up table and have them auto-populate when the key field from the look up table is selected

- Create a query that joins the tables and use the query as the recordsource for your form or report rather than a single table.