Information générale
Titre:
Field Level Validation
Help. I am fairly new to VFP so I'm having trouble figuring out how to do some things. I have a table where JOB_NO is a field and primary key.
On a form, when a user enters a job_no, I want it to check then whether this is a new job no.
My thinking is this should be done in the Valid of the table for job_no. I just don't know how to check to see if its a unique number without moving the record pointer which causes a recursive error.
I cannot generate the job_no on the form or with the default value because it is keyed from a hard copy, and I don't know what the next value will be.
Any help/suggestions is greatly appreciated
Phil
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement