VBA code, in Form, to check a Table, to see if a part has already been tested.

[June7]

Posts 2 and 10 describe compound key, in your case, MeltCharge and Diameter together determine a unique record in SteelInfo.

[arneym]

Before we can proceed, need to get table relationships committed. Do you want to use the autonumber ID as PK/FK since it is designated as the PK and is designed for that or do you want the compound key?

June7,
I started over. I do not have any forms created yet. Would you mind looking at my tables and relationships and see if they look correct?Cut.zip

[June7]

Yes, if you want to use compound key that's how it's done.

Name parts should be in separate fields. Makes sorting/filtering by lastname much easier.