Hi Sylvain,
Your right, I wasn't buffering. I will explore this some more and probably come back with more questions. Thanks for the help.
>Are you using table/record buffering? If not, you will have to trap the error with a ON ERROR (yuck!). With table/record buffering on, you just need to check the return value of TableUpdate() to know if there was a problem.
>
>>I've attempted to make this a candidate key. I get an error when a duplicate record is entered. How do I trap that error and replace it with something a little easier to understand? The person who is going to do the data entry as asked my to their desk twice to fix their system when the monitor was shut off. An error like 'uniqueness of index violated' will mean nothing.
Jim Philippi
quando omni flunkus moritati