I am wrapping up an inspection app and a customer records app. For the inspection form (annual inspection table), each inspection item answer is referenced to the inspection status table. Since there are about 100 inspection items, it was much easier and faster to use the ref to the inspection status table rather than type in each option 100 times in an enum field.
That gets me to the issue I am trying to solve. We want to show each inspection item for an individual inspection that has the answer of 'service recommended'. In the table, when the inspection is completed, each row shows an inspection, and each inspection item has one of four answers, with service recommended being one of them. I have tried various list functions without any success in showing the summary desired.
Any thoughts would be greatly appreciated.
LinkedIn
Twitter
