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
LinkedIn
Twitter
