I'm trying to develop a workflow for project management. My first step is to have the sales rep fill out a basic form called "New Project." In this form the sales rep fills out a few fields, including the "Project" field. Once that form is submitted, I direct three different people to three different forms, all of which need to be tied back to the Project.

In the Promo Form, for example, I can use a lookup of New Project->Project to get a drop-down of all projects. Then the user fills out the rest of the form accordingly. I can do the same with the other two forms as well.

The problem is tying them all together. I want to create a master view which holds all entered data for all forms with the Project being the field that relates the various forms together. How can I accomplish this?

Thank you,

Chris