Does anyone have any suggestions? I tried tying the report back to the product names, but it still picks up the ID number. I tried tying it back to the junction table but it instead duplicated products for every business line instead of just picking up the individual line items as entered into the main table.

Is it in a combo box? If so, what is the row source and bound column set to?

Yes.  The originals are both tied to combo boxes.  The product combo box pulls off the product table and the business line combo box pulls off the business line table. The report is tied to a query that includes fields from the main table that includes both of the combo boxes as well. The drop downs have the actual names of the products and LOBs, but in the main table the LOBID and ProductID are stored in the LOB and Product field, so that is what is coming up on the report.  Everything worked fine until I went to run the report.

Build a query that joins the tables on the relationship keys, then use that as the Report Source

Hi Alex.  I tried that.  When I built the query I used the fields from the main tasks table and took the LOB and Product fields from their respective tables, but then it duplicated the tasks for each LOB Product regardless of what the task dictated in the main table. It was odd.  I have my relationships set up between the smaller tables and the main table and you would think it would pull it correctly, but it did not and I am at a loss as to why it is doing this.

What's the underlying SQL for that query?

The report is run off a query that pulls the LOB field and Product field in, along with the activity name and the ID of the person who is assigned the task. As I mentioned, the data has been normalized, so the LOB and Products are now housed in separate tables with LOBID and ProductID and in the task table under the product name or LOB name instead of the name.. it shows the numeric ID value- which is what it is supposed to do when you normalize (according to the videos I have watched).  My question is how do I reverse this so that when I run the report it gives me the actual string values (names) rather than ID numbers?  Is the only answer to go back and undo the normalization and put everything back into one table?

Some structural background:  The LOB and Product fields are combo boxes made with the wizard that get their data from their respective tables.  The Active LOB table has only the following fields : LOBID, LOB and the Active Product Table has ProductID and Product.   The row source for the LOB combo box is based on a query and the in the row source it says: SELECT [Active LOBsQ].[Lines of Business] FROM [Active LOBsQ] ORDER BY [Lines of Business];  (again the wizard did all this) when it asks where I want to store the values I tell it to store them in respective field in the main task table- under LOB. The drop down for the combo boxes have all the correct names. No issues there at all. But in the table it is storing the LOBID instead of the name. On the report it gives the LOBID instead of the name too.

Also the respective tables are linked to the actual main via LOBID and ProductID with no referential integrity checked. I need to get this fixed before Tuesday AM. Please help. I have spent all weekend trying to figure out a solution.  I really dont want to rebuild all my tables and pages...