Need report to list Table A records with no matching Table B records

Need report to list Table A records with no matching Table B records

Hi

I have two tables:
  • Table A (Jobs) has Job Number (Autonumber) and Job Name (single line)
  • Table B (Visits) has:
    • Lookup on Jobs (Job Number)
    • Visit Date/Time
I need to create a report that shows all Jobs where there has not yet been a Visit linked to it, but I can't see how to do this in Creator.

I can see how to report on visits and link them to Jobs, but cannot see how to reference Visits (or the lack of them) in a report based on Jobs.

I have attached a Deluge Script export of a simplified version of the application.

All assistance appreciated!  Many thanks