Microsoft Office Tutorials and References
In Depth Information
Creating a table by using application parts
Add an application part
5 Choose the field to look up.
6 Type a name for the lookup column.
7 Click Create.
8 Three new design objects have been added to the database.
9 The new lookup field now displays data from our existing Contacts
TIP Access supports lookups that can store multiple values.
This feature saves you from creating additional tables, which
would otherwise be required to hold the multiple selections. In the
example, we could have made this selection store multiple contacts
against a single task.
TIP It is also possible to create your own application part to
allow you to quickly add a set of objects to your database. The
following article from the Access Team provides details on how to do