Creating an estimate number based on the client/event

[geraldh]

Hello All,

Event mangement problem here. I would appreciate any suggestions.

A number of estimates may be created for the same client for the same event (until the client figures out what exactly he/she wishes).

I have a field called EstimateVersion and I would like it, if possible, to automatically calculate the "number" of the new estimate (in other words, if this is the 1st estimate it would populate with "1"; if it is the 4th estimate, it would populate with "4").

I've tried various ways using GetField, and ways using related records; but can't seem to make it work.

In the end, it is not much of a problem to input this myself, but it would nice to get this automated.

Thank you

[Fitch]

I presume that Estimates and Clients are separate tables, related by Client ID. In the client table, Count( Estimates::ID ) tells you how many estimates exist. Other functions you might use are Last or Max. Does that give you enough to go on?

[geraldh]

Fitch,

Thank you. I will try this, and it makes so much sense I can't see it not working!

Thank you again,

G