Show if a parent record has a child record.

  • Thread starter Thread starter news.online.no
  • Start date Start date
N

news.online.no

In a query, I need too return "Yes" if the parent record has a child record.
All records in parent tabel must show.

Using this query in a combobox on a form too select records.

Thanks.

:)
 
Something like this UNTESTED SQL may work for you.

SELECT Parent.FieldA,
Count(Child.PrimaryKey) <> 0 As HasChild
FROM Parent Left Join Child
 
Back
Top