Related Record Count Problem

[Greg Hains]

Hi.

I have a database that has two tables. The first being the client list itself, and a second being of their visits to a store.

Clients have between 0 and many visits recorded in the second table and they are related. When I go to a related record from the client table and there are 1 or more visit records then I can get an accurate count, but if there are no visit records then I get a return FoundCount of the number of client records.

I have been experimenting with errorcodes and the like to try and establish how I can accurately detect zero visit records, but with no luck.

Anybody got a suggestion please?

Greg

[IdealData]

Create a calculation field in the Clients table:

Count (VISITS::AnyField)

Assuming VISITS is the relationship, and "AnyField" is any field in the related table.

[comment]

Make sure you pick a field that cannot be empty - such as Visits::ClientID, for example.

[Greg Hains]

Thankyou to you both. That worked well.

Cheers,

Greg