How to use Lookup in table creation

C

clara

Hi all,

When I create a table, there are two tabs;General and Lookup. the content
under the general tab is straight , but what is functionality of Lookup tab?

Clara

thank you so much for your help
 
A

Allen Browne

The Lookup tab in the lower pane of the table design window allows you to
specify the kind of control you want to use for the selected field. It
defaults to Textbox, but you can choose another option such as Combo.

In general, it's not a good idea to use combos in your table, especially if
the display column is not the bound column. Combos are great on a form, but
if you use them in a table, they are likely to confuse you about what is
actually being stored there. Here's more info about that:
http://www.mvps.org/access/lookupfields.htm
 

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