I need some assistance with relationship structure for MS Access 2010.
The purpose / goal / outcome ... is to track vendor certification/acreditation compliance / cert expiry dates
Key table/data sets
- Company (includes all vitals and separately links to contacts within company)
- Product Category (there are approx a dozen of these, but some companies can have more than one)
- Products (each Product Category can have many Products)
- Certifications (there are hundreds of certifications/specifications types ... some products have none, whilst others may have one or many)
End goals:
- A Form to Select for Companies which Product Categories they have (1 or more)
- this then cascades to Select the types or Products within each Product Category for that Company (some may have only a few, some may have all)
- based on the selected Products ... there cascades (automatically) the required Certifications for each Product selected
- User input fields to enter actual Company certification numbers (or option for N/A) and the cert expiry date for each 'required certificate'
- Notification can be programmed to alert for expired certificates.
The purpose of the DB is to:
- Monitor multiple companies for certification compliance to manufacture products
- Monitor for expired certs
- Provide other useful searches for compliant Companies by Product categories, Products or Certificate Types.
Disregard any links shown, these are the tables I created to be linked.