I need help figuring out the missing piece on a Generic Inquiry.
I want my users to be able to pull up a list of items needed for Planned, Released and In Process Work Orders. I have an inquiry started but it’s listing some items multiple times and it shouldn’t.
The goal is for them to be able to see how much of Item A they need for the next 3 days or so and how much of Item B they need and so forth.
I’m attaching screenshots with the linking currently on the inquiry. I think I have a join wrong or maybe there is a link missing…
I would appreciate any input or if there is another way to get this info, please share.
