Show Primary Part Bin when none on hand


We have parts that have a primary bin assigned in the Part Entry form but there isn’t any on hand quantity. I have been asked to create a dashboard that shows the bin for the part regardless if any are on hand or not. How do I get to that bin when there are none on hand? I can see it in the part entry form and that the field help shows it is from PartWhse but I don’t see a bin in the PartWhse table when I try to build a query. I have tried tying the part table to the PartBin table but since there is no on hand quantity it doesn’t show the bin.

PrimBin is located in the PlantWhse table.

1 Like

You’re going to have to make a union so that you can show the extra rows that you need in the query.