469,360 Members | 1,807 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,360 developers. It's quick & easy.

Alert or Preventing data entry?

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.
Nov 12 '05 #1
1 1335
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.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Wayne Aprato | last post: by
2 posts views Thread by Seth | last post: by
5 posts views Thread by Darrel | last post: by
19 posts views Thread by ivan.leben | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.