Populate field according to value of another field

[gcomp]

I have a report that lists among other items "Part Number" and "Part Description". Both items are stored in a table called "CustomInventory". I have another table that stores items for a work order. "Part Number" is stored in this table called "ProjectData" according to the project. The part numbers in both tables correspond with each other. The report is based on a query using the "ProjectData" table. How can I populate the Description field in my report from "CustomInventory"?

Reading my post back confuses me, so if you need more info, let me know!!!

 

[pbaldy]

The report should be based on a query that joins the two tables together on the number field, which enables you to include the description field in the source.

 

[vbaInet]

Create a new query, select the necessary fields from the ProjectData table then also select the fields from CustomInventory. Access will create the join for you.

Now use this query as the Record Source of your report.