OK. As usual, this is a question that might be a little odd. I have a custom field on the production order called “JOB”. When creating an order that has multiple subassemblies I want to identify/filter the orders by “JOB” so. I am trying to figure out a way to show the “JOB” number from the product order on the same line as the associated subassembly. Something like this. I thought I might be able just pull in the AMPRODITEM twice once for the product and the other for subassembly and do some kind of IIF to pull in the “JOB” but hit a wall there. Thoughts?
ORDER ITEM PRODUCT ORDER JOB
67890 TACOS 12345 TACO MACHINE
Best answer by lauraj46
View original