Company to Contact Confusion

[Rapt Productions]

Hello, thanks for taking the time to read my question. I have an idea of what I want to do, but I'm mixed up about how to go about it.

Basically, I have a "Contact" table and a "Companies" table.

From the "Contact" table, I need to be able to

A) Create new records in "Companies"

: Select existing companies from a drop down

From the "Companies" table, I need to be able to

A) Create new records in "Contact" (First Name, Last Name, Phone Number, Email Address)

Select existing contacts from a drop down list sorted by name

I apologize for the disjointed explanation - as you can probably tell, I'm not really sure how to think think about this problem, let alone solve it. Thanks again for any help.

[Robert Schaub]

This year I built a system where a person only exists one time but may be asscioated with more than one organization.

Hers's a pdf link that may give ou the idea.

http://starrdata.com/Starr_Data_Samples/People%20Connector.pdf

[Rapt Productions]

Thanks Robert. Truth be told, that went way over my head - but I appreciate it!