BAQ help - full join

Epicor ERP 10
1

I am working a project where I require a full join between PARTBIN and a custom table that represents counts.

The issue I have is that unless I put both the PART# from both tables - the records where there is not a 1:1 do not properly show PART#. For example, if I use PARTBIN.PartNum, records that only exist in my count, but not PARTBIN have PartNum blank. The same condition occurs vice versa. (Pay no attention to my mismatching column names)

image
image.png834×115 2.38 KB

Any thoughts on the best way to deal with this? Worse case, for every PARTBIN record I can copy a blank record into my COUNT table.

2

Hi Chris,

How about using a calculated field to display your Part no and make it = Part from table 1 if not isnull and then = Part from table 2 otherwise?

Nancy

1 Like
3

Brilliant - thank you!