Apologies, I know this question must have been answered, but I just can't find the right post.
I have a simple dataset which uses 2 Lookup fields to filter the data. I've not used code for this, just simple filtering of datasets.
My one problem is that I want to display data if the lookups are not populated.
One Lookup is Site (Different Locations)
One Lookup is Service (Different types of Services)
So they work fine, when both options are selected, but I want all data to be displayed initially, and only if one of the lookups has a value selected, then it should only filter that element.
ie. Select Wales in the Site, I want all Services to be displayed within Wales.
Is it possible to do this without code? or of code is required, could you point me in the right direction with clear instructions, as code is not my strong point unfortunately.
Thanks for any help