Hello,
I have a database with 2 Tables; an Agent Table, and a Staff Table. I have split up these 2 Tables because Agents have different information than Staff. I have made a 3rd Table for a Phone List. I wanted to create just 1 Table for the Phone List because I want all the phone numbers in one Table.

The question is; can I create a Form based on the Phone List and use it for both the Agent Form and the Staff Form; which are based on the Agent Table and Staff Table respectively?

What I really want to do is to create a Phone Sub Form based on the Phone Form and use it in the Agent Form and Staff Form.

Please advise and thank in advance for your help.

Amir.