I am trying to hide a column โinitial delivery quantityโ in a deliveries form if it is the second or any subsequent delivery to the same address( a key value). The idea being when you pick the delivery address from the dropdown menu on the delivery form, it will hide the โinitial delivery quantityโ from the form if Iโve delivered their before. Canโt get me head round the problem. Can anyone help? Tried this in the show_if section:
COUNT(SELECT(Deliveries[Product], [Address] = [Address Name]))=0
โAddressโ in the Deliveries table and is a REF to โAddress Nameโ in the customer table
How about COUNT(SELECT(Deliveries[Product], [Address] = [_THISROW].[Address Name]))=0
Worked a treat, thanks Alkio.
Youโre welcome
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |