Alert or Preventing data entry?

[Randy]

I am using Approach 9.8 and have set up a appointment database with
the following fields.

DATE, TYPEACTION, TIME, WORKER LASTNAME FIRSTNAME

I do not want my clerical staff to be able to key in a date if

DATE is the same, TYPEACTION=LEAVE, AND WORKER is the same.

I can use the Combine function and prevent data entry by using a
modification formula and unique code to prevent a duplicate entry for
DATE, TIME, AND WORKER.

I have been unable to get it to give me an alert though for
Combine(DATE, TYPEACTION ='LEAVE', WORKER).

Any help with this problem would be very much appreciated.

The reason I am using this newsgroup is that I am not getting any
answers from the Approach group.

Thanks for any help.

[Philip Sherman]

I've no idea how to do this with Approach but you should be able to use
an INSERT trigger to prevent a duplicate row for the specific 'LEAVE'
action. The trigger can raise an error that would be passed back to the
application as any other SQL error is.

Phil Sherman
Randy wrote:

I am using Approach 9.8 and have set up a appointment database with
the following fields.

DATE, TYPEACTION, TIME, WORKER LASTNAME FIRSTNAME

I do not want my clerical staff to be able to key in a date if

DATE is the same, TYPEACTION=LEAVE, AND WORKER is the same.

I can use the Combine function and prevent data entry by using a
modification formula and unique code to prevent a duplicate entry for
DATE, TIME, AND WORKER.

I have been unable to get it to give me an alert though for
Combine(DATE, TYPEACTION ='LEAVE', WORKER).

Any help with this problem would be very much appreciated.

The reason I am using this newsgroup is that I am not getting any
answers from the Approach group.

Thanks for any help.