By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,925 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,925 IT Pros & Developers. It's quick & easy.

Alert or Preventing data entry?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.