The goal is the show a list of addresses that can be selected and are associated with an email address listed above in the form,
It’s a REF with the following valid if
SELECT(Related_Customer_Address[Address],([Customer Email]=[CustomerID],TRUE)
It works, but I’m getting the yellow !
Is it column type?
Thanks!
Its maybe because the [Address] is not your key for the Related_Customer_Address table.
Try to change [Address] to the Key column and make the [Address] column as the Label of the table.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |