At work I am trying to create relational tables for excessive orders. In one table is the Master Product List which shows all of the SKU's my company produces and the Material Planner who orders for that SKU. To help out the Demand Planners on the Excessive Order table I have the SKU listed. Based on the SKU in the EO table I was hoping to have a lookup function directly input the Material Planner from the Master Prod List table. For the life of me I am forgetting how to do this and I know it is probably real simple. For the record we use Access 2010 if that makes a difference.

I dont know if I'm understanding this right or not..but I think you need to create a parameter query.

That is one way I can do it. My dept has very few people who understand Access so I was trying to make this as automated as possible for them. Our demand planners will enter data into the table and I was hoping this info could pop right up in the table as opposed to having them go into a Query. If not, no biggy.

how about creating a form with a subform? Im no expert on this or anything but im taking an access class right now we were messing with this. You type in whatever information in the form, then it brings up the info in the subform. Pretty sure you can set it so that the form opens when the file is opened as well so they dont have to do any navigation.

Cool I will check into that. Thanks!

Sounds like the function you want is DLookup. But depending on the size of your database, the domain aggregate functions can be notoriously slow (and the syntax is a real pain). You could probably also create a query that concatenates the Order and Mgr in one field. And you could jury-rig what you need from that (cut-off the mgr in that field by limiting the column width and then in the Mgr field just do a Left(...) function).