Is it possible to make a related table requir...

Is it possible to make a related table required based on answers to questions in the main table?

Ex - see attached.

If person says yes to cat, dog, other we want to require them to complete the pet registration.

0 2 332
2 REPLIES 2

You could write a Valid_If rule like COUNT([Pet Registrations])>0

Hi @Tammi_Canelli, Based on my understanding of your requirement, you can try the following,

In the main table, you have related column of reverse references for the

Pets information table. Say this virtual LIST type columnโ€™s name is [Related Pet Information]

Please put following expression in the Show_if definition of this column

OR([Pets]=TRUE,[Other Pets]=TRUE)

Where [Pets] and [Other Pets] are two Yes/No type of columns,

Hope this helps.

Top Labels in this Space