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.