I don't know how to search for this. Sorry. I have created a table that has a list of names and each has an id number. I have a form with 4 drop down boxes that select a name (there can be 1 to 4 on each form). These are people who need to approve a change to a document. When the name is selected, the id number goes into a table under Approval 1, Approval 2, etc. (as needed).
Now, I want to create a report from those forms. I cannot figure out how to get the ID numbers to show the names on the report and it's driving me crazy. I have tried several queries and can get one to show what I want but I cannot figure out how to get (in this case) the other six records. I want to have something like this: Doc. No. Title Approval 1 Approval 2 Approval 3 089P0002 Document Control John Smith Julie Brown 022MU012 Design Change John Smith Barbara Smith Joe Baker 012P0003 Parts Julie Brown I keep wondering if there is a way to write an expression in the report that would make the number equal the matching title from the table that contains that information? Thank you anyone! Anne W.
