Data Entry forms

[Karly]

I am trying to set up a form for data entry into my contact database. My
tables are:

Contacts table:
ContactsID
ContactName
OrgID
Other info associated with contacts

Company table:
OrgID
OrgName
Other company info

I have linked the tables together using the OrgID as the foreign ID to the
contacts table and have set up a form where the company field is a drop down
list and its values come from a look-up a query of the Company and Contact
tables. However, at the moment everytime I enter a new contact, after
selecting a company from the drop down list, instead of returning the
associate OrgID of my chosen company, it adds a new record to my Org table
with a new OrgID. I also get a promt to enter a "Parameter value - Company"
everytime I open my page. What have I done wrong?

Thanks!