Hi @Tammi_Canelli, Grant’s guidance is correct.
I also saw your other post , where in you have requirement of enabling related table record only if user responds with [Pets]=Yes or [Other Pets]= Yes in main form…
Continuing the same thread, you may wish to try the following to ensure that if user enters either [Pets]=Yes or [Other Pets]= Yes ,then
she/he enters at least one related record, without which the form cannot be submitted.
- Please create a virtual column , say with name of [COUNTPETRECORDS] of Number type in main table. Please have
expression as COUNT([Related Pet Info Column Name]) in this column.
Please include this virtual column in the main form with suitable heading.
This related column [Related Pet Info Column Name] is reverse reference column in the main table for pet information table. I think we have previously discussed this in other post.
- In the Valid_if of [COUNTPETRECORDS] , please enter an expression
=OR(AND((OR([Pets]=TRUE,[Other Pets]=TRUE)),[_this]>=1),AND((AND([Pets]=FALSE,[Other Pets]=FALSE)),[_this]=0))
above expression will ensure that if the user enters “Yes” for pets or other pets question fields,the main form can be completed only if the user enters at least one row in the related record.
I did a basic testing of this expression.
Hope this helps.