kitto
Posts: 3
|
| Posted: 08/09/2006, 7:12 AM |
|
I have record form referring to table s_Activations.
On record form, I have input fields <StartSerial> and <EndSerial>. What I want is that when value is put in <StartSerial> it should check if this does not exist in range <StartSerial> to <EndSerial> of all records in s_Activations table. If it do exists then it pop up error and restrict the entry. I will give you an example, for instance a record exist:
<StartSerial> <EndSerial>.
10000 20000
When new entry is to made in <StartSerial>, for instance 12000 this should be blocked as 12000 exist in range of 10000 to 20000.
Please help me to sort it out step by step. I am ready to pay by paypal.
Nick
|
 |
 |
|
