I am creating a form to collect inspection information. The db essentially is made up of three primary tables - Buildings, Inpections, and Violations. Each building has a unique ID and each building may have several inspections with each inspection having its own unique ID. Naturally, each inspection may also have several violations. I have created a form containing the building information and inspection information based on a query linking inspection data to each building by building ID. I also have a subform used to collect the violations for each inspection which links each violatin to a particular inspection by inspection ID. My question is how can I automatically have each violation associate itself to the current inspection ID as it is entered? Any help would be greatly appreciated!

If you set the master/child link fields properly for the subform, Access will automatically associate the violations with the current inspection.