Hi,
I have two tables (TABLE A and TABLE B)
I have identical four records in both.
I am wondering if there is a way to get the value I want in TABLE C Row4 highlighted in yellow.
The link is PegPart in both tables, i.e. Part MEM002 has a PegPart MEM001.
I cannot think of a way to get PlannedOrder to PlannedAllocation record in one row (i.e. the logic for it).
Bookmarks