NOOB here to filemaker (I have some SQL and Access and other coding experience) and loving it so far.
I’m currently building an inspection tool for inspectors in our company, One thing I’m struggling at the moment is to populate any given inspection/questionnaire with the relevant questions to the inspection.
I have a master question list table in the format below
Question no, Question, lift type (check box list to choose from)
Basically, when the inspector is on site he/she will enter what type of lift they are inspecting by ticking a checkbox, this should then populate the relevant question on the inspection form.
Any ideas how can do this efficiently, I can do it a clunky way by conditional formatting but means I have to manually type the questions instead of inserting it form my question table.