Auto-populate question over multiple tables

[Mitch Johnson]

I work for a construction services company.
I have three tables:
Contacts
Companies
Projects

I want to complete a basic contact form, where their company, business address, contact info, etc. can be accessed into Companies and Projects.

In my Projects table, I can use Lookup to select a company. I'd like to be able to access only the contacts from that company. Furthermore, each project may have a separate contact, depending on company size, so I'd like to be able to select a single contact person and have their full name (from 2 columns into 1 or 2 columns, their contact number, and their email address all to populate the corresponding tables in the project entry.

Thanks in advance.
Mitchell

[mshmyob]

Is there an actual question here? What are you having problems with? Any code you need help with?

cheers,