I am looking for some advice on how to set up my tables for a database that will track inspections on items my company is producing. A currently have three tables for this. The first one 'JobDescription' has the job number, customer name, etc. The second, 'ItemDescrition' has the item number, revision, etc. The third, 'InspectionDetail' has the type of inspections, inspector, date performed, etc.
My goal is to be able to set up a form where you can pick the job from a list of combo box that would then filter for any items on that job. You could then pick the item you wanted and the form would show you all of the inspections done for that item and allow additional inspections to be made.
Any help anyone can offer would be greatly appreciated.