Where is this project currently? Analysis? Design?
Do you have a more complete statement of requirements?
Providing readers with more detail of
WHAT is required will help you get more specific responses and possible options of
HOW you can proceed.
Autonumbers are primarily for use by the database management system. They are not meant for user/human consumption generally. With a relational database your data should be
atomic--one fact-one field. If you need a number/code for human use, you can create same by combining/concatenating atomic values.
For context, what is it you are checking for "
conformance"? What rules apply in simple terms?
You issue a CAR to a person/company when your check shows "
non-conformance".
Your Form and List represent
HOW you have used Access to represent/support your business. I'm still asking for details on the
WHAT part of the requirement.
Good luck with your project.