This is probably easy for some but its stumping me a bit. I have users entering the number of businesses that are present in a property. After that they collect the property records with an inline form. basically I would like to:
compare the total with a count of entered inline records. If these are equal, then they can save. See image. Any suggestions?
Please try an expression something like below in the Valid_If of [Total Number of Businesses] column
[_THIS]=COUNT([Contacts and Businesses])
Here [Contacts and Businesses] is assumed to be reverse reference list type column in the table.
Thanks Suvrutt, this put me on the right track.
User | Count |
---|---|
16 | |
13 | |
8 | |
7 | |
4 |