I have a slight problem, I have a Master detail relationship with 2 databases.
1) Customer Database = Master.
2) Debts Database = Detail.
I would like to navigate though the database and if the record count in the debts database is 0 then I don't want to see the master record.
The problem is I have records being printed when no detail is available.
How can I get round this?
300 Points to the best example that works for me.