In an apartment building, a one key is related to only one apartment.
However, an apartment may have several keys.
I have two tables: Keys and Apartments
How can I link both tables so I can:
1) In the Keys layout:
a-Select what apartment a key belongs to
b-See what apartment a key belongs to
2) In the Apartments layout
a-I need to be able to select or create a new key that belongs to it.
b-List the keys that belongs to it.
c-Update the keys that belongs to it.
Thanks for you help,