set a temporary error routine, attempt the INSERT, and trap for error 1884.

This might be great for the new TRY/CATCH in VFP8.

>>Is it feasable to have a candidate index on this combination of fields?
>
>This is a new table so I could design it in any way I wish. Can you tell me more about your idea?