I am creating a database that tracks inspections of assets and logs the findings from the inspections. I have a table of assets, a table of inspections, and a table of defects. An inspection can note multiple defects, and a defect can be present across multiple inspections of an asset, so they have a many-to-many relationship through a join table.
I would like to create some sort of pop up form when logging a new inspection that allows defects noted on the previous inspection of an asset to also be associated with the new inspection; the most appropriate format for this would be something very similar in appearance to the creation wizard in access, where there is a list of defects from the previous inspection on the left, and buttons to move them over to a list on the right, whereupon a record would be created in the join table associating the InspectionID with the DefectID. There will be an additional button to create a new defect log if anything new is noted during an inspection.
As I mentioned in my previous post, I am very new to Access and probably trying to run before I can walk, but currently I am handling the creation of inspection reports manually in Word, which is extremely time consuming, and the sooner I can migrate my work to a database the better.
Thanks in anticipation,
Phil