I have checked many different ways and cannot figure out how to solve my current problem. Can someone help me?

What I am trying to do:

I want to have a summary field that will display the count of records with the entered value during the data-entry step of a new record.

Illustration:

Field A (text)

Field B (date)

Field C (count number of records for value of Field A that are already in db)

Field D (Max date for value of Field B, as it relates to Fields C & A already in db)

What I need FM to do:

(1) When a user enters value 'ABC123' for Field A, I want Field C to auto-populate with the next sequential value, which indicates the number of times the value of 'ABC123' has already been entered in previous records. AND

(2) Have Field D auto-populate with the most recent value of Field B, as it relates to Field A.

How do I do this?

Further detail, in case I am not 100% clear:

A B C D

ABC123 1/1/02 0 <null>

DEF456 6/1/02 0 <null>

ABC123 8/1/02 1 1/1/02

When a new record is created, and the user enters 'ABC123', I want C = 2 and D = 8/1/02

Can you help me?:

Muito obrigado!

Define Field C as a numeric auto calculation of Count(SelfonfieldA::fieldA) and field D as a date with auto calculation with Last(SelfonFieldC::FieldC) where the relationships are :

CurrentFile:fieldA::CurrentFile:fieldA

CurrentFile:FieldC::CurrentFile:FieldC