AnsweredAssumed Answered

show related data of same table

Question asked by HB on Jul 12, 2016
Latest reply on Jul 13, 2016 by HB



How can I show related data that exists inside same table.





MainNum1=A1 SecNum1=zzz  Loc1=There

MainNum2=zzz SecNum2=67  Loc2=Here

MainNum3=A1 SecNum3=yy  Loc3=Here

MainNum4=yy SecNum4=88  Loc4=Here

How can I find all the MainNum's whose SecNum's location is not There


ie If table were only the 4 records above

I would like to perform find that shows just the first record because zzz's location is not "There"


Thanks in advance