Tables and Relationships

[jenvandiver]

I am collecting information on X and need to include information on points of contact. There are two types of contacts: technical and contractual.

I have:

tblContact
Contact ID (autonumber)
Contact Type ID
Contact First Name
Contact Last Name

tblContactType
Contact Type ID (1 or 2)
Contact Type (technical or contractual)

My question has to do with linking this data to a tblTEP that holds all the information about X. I'd like to have a form where the user enters data, and once they get to the point where they need to enter contact information, they can choose from a drop down a list of technical contacts, then from a separate drop down, a list of contractual contacts. I know this is a simple relationship issue. Can anyone help?

Thanks!

 

[FoFa]

You can create the two pull downs using a query to seperate the types of contact, but you only have one place to store this information, if they select one of each, what you planning on doing? Or maybe I don't understand the question.