Querying multiple tables

[rassoc]

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

[orange]

No image provided??

[Micron]

Did you try using the query builder? This ought to be quite simple: drag both tables into the table/query portion, join on the 2 id fields (drag primary id onto secondary id), add your fields to the grid and enter that criteria in your date field.

[Welshgasman]

I have set up the relationship as per the image below

You cannot just paste an image here like you can on other forums. Whilst it appears to be pasted, it gets removed when you post. You need to include it as an attachment. Then a thumbnail pic will be siplayed as a link to the actual pic.

[kd2017]

Both "Properties" and "System" are reserved words. I suggest changing them, and any other object names, to something not in this list:

http://allenbrowne.com/AppIssueBadWord.html