Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two tables having many columns.
Supplier1:
Load PartNumber,
Supplier1Name,
.
.
.
From .......
Supplier2:
Load PartNumber,
Supplier2Name,
.
.
.
From .......
Now, I want to use only one field Supplier2Name from Supplier2 in Supplier1 table but do not want to use Left Join or Right Join function.
After displaying table showing all fields of Supplier1 + Supplier2Name, want to create a button. The criteria is when I click this button, the table will show only those rows where Supplier1Name is not equal to Supplier2Name.
Thanks for your help
No problem. If any of the solutions worked, please mark as correct for the benefit of others searching for solutions.
Will do but I have to implement the same efore marking