AnsweredAssumed Answered

Relationship help

Question asked by liltbrockie on Aug 7, 2018

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!

 

Any advice?

 

So to clarify..

 

If one sales order has lines,

 

Test1

Test2

Test3

Test4

 

And another Sales Order has

 

Test3

Test1

Test4

 

Then that would be a match because at least 3 lines match

 

 

But Sales order with

 

Test1

Test4

Would not match because thats only two matches...

Outcomes