adding a counter to a field

Adding a counter to a field I have 5 fields... 1. Appraiser Number 2. Year 3. Client 4. Appraisal Number 5. Folio Number My problem is that the Appraisal number field has to do the following: - the Appraisal number field is the number of appraisals that we have done for that client for that specific year. How can I create this counter? Here is an example: Appraiser Number: 22 Year: 02 Client: 112 Appraisal Number: 317 Folio Number: 54093 This means that we have done 317 appraisals for client 112 in 2002. Note: As soon as we enter the client number, I want a message box stating "Would you like the Appraisal Number to be 317?" If yes, then it adds 317 to the Appraisal Number. Once the date changes to 03, the counter goes back to zero. Please keep in mind that this database has over 60000 records. I'm just adding a few fields to the database. The old counter isn't there since the old databe was done in VB.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

access 2000

tekniikka Microsoft Access MySQL PHP Tietojärjestelmäarkkitehtuuri Ohjelmistojen testaus

Projektin tunnus: #2923572

Tietoa projektista