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.
You’re going to have to make a union so that you can show the extra rows that you need in the query.