>: What command can I use on the view to determine if a record exists? Using
>
>: local tables I used SEEK. The user entered a claim number, and if it was
>: found they could continue. How do I duplicate this on a view?
>
>this is exactly where a parameterized view on claim number will work
>you enter the claim number and the requery the view
>
>Arnon

I still don't understand. When the user enters a claim number, I want to be able to check to see if the number exists in the table first. Is there a command that says "run the parameterized view, but if the result is empty then close the view and do something else?" In other words, is their a substitute for the SEEK command I can use on the view?

Jeff