If i have 2 tables

Table_Projects and Table_Orders

Table_Projects got fields:
Project
Number
Status

Table_Orders got fields:
Project
Order_Number

Now i have a report and all my data from Table_Orders are showed in my Report.
But i want also Data from Table_Projects in my Report, based on:

If Table_Orders.Project = Table_Projects.Project then

Table_Project.Status must be showed on the report in a Field.


So if i change my status in Table_Projects it will change also on my Report.

Can i do this with VBA when my report is starting or just add a new field in my report and add codes to it.

Hi,

(IMG:style_emoticons/default/welcome2UA.gif)

I think you should be able to adjust the query that your report is based on to include the other table and the required field from it. Then, just add that additional field from the query into your report.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)