Neal, Your pictures are what I am trying to get at. After I posted my question I did come up with a solution that seems to work but it may be a bit cumbersome. Table 2 inspections - What I did in my inspection table (Table 2) is created a formula fi...

I am looking for the same thing as well. In my case Table 1 holds company information (many companies) and Table 2 holds inspections that either pass or fail (all inspections for all companies by date). I have a roll-up field in Table 1 that collec...