I want to enter new data into a lookup field...

D

Dr. Darrell

I have several tables with several lookup fields.

If I don't see the data I want in the drop down list, I would like to enter
a new value.

Example:

I have a lookup field linked to a Drawings Table which has the following
Drawings listed.

Dwg-0001
Dwg-0002
Dwg-0003
Dwg-0004

I want to enter a new drawing number “Dwg-101-101-2000â€

Can I format my field to allow both a lookup field and the entry of a new
value which will be entered into the lookup field’s table?


Darrell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top