Having trouble sorting records in list view
I have a basic audit file with four tables Audit, Audit_Question, Questions, Audit_Types
Basically an audit pulls the correct questions from Questions and allows for response to the question in the audit_question join table.
There are 36 questions that all in to one of three audit_types: Hole Watch, Fire Watch, Bottle Watch.
When I try to make a list layout that views only the questions from that category for that particular audit, it still shows all of the 36 questions.
The script I tried was Go to related record from Audit_Question using layout Audit Report.
Find Matching Records using _fkAuditType (constrain)