AnsweredAssumed Answered

Having trouble sorting records in list view

Question asked by CalebTurner on Jun 3, 2014
Latest reply on Jun 3, 2014 by philmodjunk


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)

     Any ideas?