Table-to-Table Relationship Question

Question

Is there a way to create a table-to-table relationship that you can use with a multiple-choice field?

For context, I am trying to create an inspection form that pulls questions from another table based on the equipment that is selected at the top of the inspection form. The questions on the inspection form need to have a "Pass" or "Fail" option, hence why I would like them to be multiple choice. Or if there were some formula that would do something similar, that could also be helpful.

Any feedback would be greatly appreciated!

benrizz17 · Answer

One other thing I thought of is if there is some formula that could somehow change the alternate label of a field, that could work as well.

To be more specific, if I could create a list of 20 "dummy" questions on the inspection form, and then by selecting the designated equipment on the equipment list that somehow changes the Q1-Q20 alternate text labels to the 20 questions on a dummy table or built into the formula, that I think would work too.

Sign up

Login to the community