471,851 Members | 851 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,851 software developers and data experts.

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 1396
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
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.