May 17 2006, 08:58 AM
OK where to begin?
I've got three tables:
ENGINEER CERTIFICATION TABLE
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!!
May 17 2006, 09:00 AM
EngID and CertID in the engineer certification table should be Long Integer data types.
May 17 2006, 09:09 AM
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!
May 17 2006, 09:15 AM
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:
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?
May 17 2006, 10:53 AM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here