I have two tables
- Properties
- System
In the System Table the Property ID field is included in each record to I can match the System record to the Properties record.
I have set up the relationship as per the image below
I need to run the following query
Return Properties Fields & System Fields Where InstallDate >=Date
Any help would be appreciated!
TIA