Displaying/hiding set of tabs/questions based on entered information
I'm stuck on creating a fairly large database frontend and I'm looking for advise/feedback. I'm in charge of creating a safety inspection database for a safety committee. The safety committee goes through each building which has offices, labs, data, janitor, etc rooms. Each room has a different set of questions that need to be answered to pass the safety check. Therefore, I would like the database to display only a set of questions if for an example, room number 101 for Building A is entered. Is this possible or any ideas on how to accomplish this?
Using FileMaker Advanced Server 11 with FMP 11