• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Lookup List

A common database convention is lookups. You might want to look up a customer address, or you might not remember the product code for an inventory item. Therefore, you need to see a list of products. You also might want to see the item itself, along with its code. Lookups can fill other controls with synchronized data.

Let’s take a look at a few techniques that use controls for table lookups. The first method uses a query to look up data. The second method uses calculated fields to obtain the lookup data. The third method combines lookups and calculations. The first two methods have a control source in the Lookup field. This ensures that the data remains when the form closes.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint