I got the Lookup table figured out. I changed the textbox to a combo box and made it a value list.
What I am trying to do now is create a passdown schedule.
This consists of a pre-schdule of parts that other departments will select from an inventory and put into 7 tables. I will then look at these 7 tables and put them in order of priority to go through what we call out Shared Services Areas. which is where the 7 tables come in. I will also need to establish a completed check box so that if the part was not completed it automatically goes onto the next days passdown.
Any suggestions on how to do/simplify this would be appreciated

---

Reply from Richard Rost:

Charles, I can't visualize what you're trying to do. Your terminology is completely foreign to me. Can you explain it as if you were talking to a 1st grader?