Add lookup after the table has been created

[forest8]

Hi there

I have created a table and realized that to ease use of adding data, I want
to add a lookup column.

How do I create a lookup column (either typed in or based on another table)
to a field which has already been populated?

Thank you

 

[Douglas J. Steele]

Don't do it!

You should never be working directly with the tables: you should always use
a form.

On a form, you can easily bind the field to a combo box.

See http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some
of the many reasons why lookup fields in tables are not considered to be a
good thing.

 

[KARL DEWEY]

Use a form with a combo box and stay out of the table.

 

[Duane Hookom]

IMO, you don't http://www.mvps.org/access/lookupfields.htm. All user
interaction should be done through forms where you can use combo boxes to
"ease use of adding data".