Is it possible to include fields from the 'Bin on Hand' sublist and the 'Bin Number' sublist on a single search without the Search results duplicating?
This is a simple search using 'Bin on Hand':
Giving this:
A single line for each Bin for that product
As soon as I include a field from the Bin Number sublist:
I get this:
Where every line is duplicated (one with the Bin Number field, and one without).
Is there anyway to overcome this?
I have tried various options of filters and groups - but the two sets of Bin fields are not related and so I always get rubbish data out.
At the moment, I'm thinking I will need to add a suffix to the Bin Number (instead of using the ranking field from the Bin Number table) - but I'd rather not do that unless absolutely necessary.
Any ideas?