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 |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |