Hey guys,
I have come around this scenario several times where I need to create a reference list using select based on the reference key of another table but then I end up with a referenced list full of duplicates. It happens with a many to many relation. Each key in the many to many table is unique so you cant use TRUE but the item repeats. If you create a total per unique item each similar item will display the same total.
What is the best practice to list those unique items with totals in one of the relating tables?
Thanks
Hyman
LinkedIn
Twitter
