I want to create a report that will take two tables that I have and link them and give me the output. Basically this is what I have: 3 fields primarily. 1. MRP Code which links the 2 tables together, 2. Part number, and 3. Planner name. I want to be able to link the part number to the planner name.
Generally I want the report to be setup so that a user can paste a large list of part numbers and the output would be the planner names associated with the part. Let me know if you can help with this.