OK where to begin?

I've got three tables:

ENGINEER TABLE
EngID (AutoNumber)
EngName (Text)
EngDept (Text)

CERTIFICATION TABLE
CertID (AutoNumber)
CertName (Text)
CertVend (Text)

ENGINEER CERTIFICATION TABLE
EngCertID (AutoNumber)
EngID (Number)
CertID (Number)

Now, obviously when I go to create the two one to many relationships (between the EngID's and between the CertID's) I get an error message saying that they are not the same data types. I understand this, but how do I go about establishing a primary key for the Eng and Cert tables without using AutoNumber (besides typing one in manually)? I hope this is clear enough to help you understand!!

Thanks!!

EngID and CertID in the engineer certification table should be Long Integer data types.

Thank you! I'm well on my way now, but with my noob status, I bet I'll have to post again in the near future!

Thanks again!

OK I knew it wouldn't be long. I'm trying to create a form where I can select the engineer name from a pull down menu, then select the certification name from a pull down menu, and have Access automagically assign an ID number to input into the tables.

I'm creating the EngCertForm with the following fields:

EngCertID
EngID
CertID

So instead of an EngID, I'd like to be selecting an engineer's name. However, I must keep the EngID field in the form, right? Should I be adding the EngName field from the Eng table?

Confused,

Jeebus

Really should have started a new question in the Forms Forum instead of adding on. Keeps the confusion down since these forums are subject based.

You'll want to use combo box controls. Access Help and searching the Forms Forum should turn up loads of information on them.