semi-unique record

[cwcrogan]

I have a table of permits and a second table of inspections. Each permit can have multiple inspections, but only one passed inspection. I have a field in the Inspections table drawn from a value list of Passed, Failed. How can ensure that there's only one passed inspection for each permit?

[comment]

Use a script to set a field in the parent record in Permits to the selected InspectionID. Use a calculation field in Inspections to indicate the inspection record that has been selected as passed.

[cwcrogan]

once again comment, thank-you.

It took me a few minutes to grasp your reply, but I understand now.