Hello CRB Forum people.

I am trying to identify records from one table that do not have a correlating value in another table, but cannot figure out how to do so.

Disclaimer: I am relatively new to CR. I have taken a training course, but am still pretty green. I have been browsing the forum and found similar threads, but the answers were too technical for me to adapt for my own use.

Table 1 is an asset record table.
Table 2 is a work routine table.
I need to select all assets in Table 1 that do not have values in Table 2 (all the records that are not assigned to routine work).

I have already created a report that shows me which routine work programs are assigned to the assets in table 1, but I noticed there are some assets missing, which means they have not yet been assigned to a work routine. I am confident CR can do this instead of me having to filter through all 3500+ records individually to find them.

Any suggestions?

In theory, that makes perfect sense.

Here is what I tried:
{WTHYDRNT.HY_NUMBER} isnull {WKRTSYSID.RS_LINK1}

My asset record is left outer joined to my work routine record.

However, I get an error message that says, "isnull {WKRTSYSID.RS_LINK1} does not appear to be part of the equation".

Any tips?
Thank you for your patience!

Thank you DBlank!

Got it. I really appreciate your help!