>Dear All,
>I have a grid in a form which is collecting information from a table. I want to add a maximum record no in one of the field in the table whenever user uses down arrow key to add new record. How do I do it? In which event I have to write the code?
Personally, I set primary keys from the field's default value (in the table structure, with MODIFY STRUCTURE). I call a function that returns the correct number.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)