Taking a look at Lookup properties
Working with Multi-Value Lookup Fields
NO matter how carefully you design your desktop database, you can be sure that you’ll need to change it at some later date. Here are some of the reasons you might need to change your database:
You no longer need some of the tables.
You need to perform some new tasks that require not only creating new tables but also inserting some linking fields in existing tables.
You need to perform some new tasks that require not only creating new tables but ...
No credit card required