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

(Tammi Canelli) #1

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.

(Aleksi Alkio) #2

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

(Suvrutt Gurjar) #3

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.