I have created 2 forms , which are linked via a lookup.

Is it possible to create a view/report that will just show records that are in the first form, that have no link in the second form

ie in database terms

Select d.*

from details d left outer join subscriptions s on d.id=s.membership_id

where s.membership_id is null

Thanks