Hi there... I am trying to build a relatioinship which will help me view, at least 3, duplicated order lines...
Imagine a simple database with two tables
Sales Orders and the Sales Order lines.....
What I want to be able to do is show, from a Sales Order, whether or not I have an existing order which has got at least THREE duplicated order lines on it...
So I have a field on the Sales Order table which is LIST ( Sales Order Lines)
And a self join on that field but it obviously does not work as expected ... but I'm not sure how to adjust!
So to clarify..
If one sales order has lines,
And another Sales Order has
Then that would be a match because at least 3 lines match
But Sales order with
Would not match because thats only two matches...