General information
Title:
Primary Key generation
Hello -
When I am on a form and adding records to it, if I don't enter data into the form and click the add button again, the record counter goes to the next number and skips as many numbers as I press the add button.
Example:
For record #1 I enter data into the form
For record #2 I enter data inot the form
For record #3 I hit the add button and don't enter data
If I hit the add button 2 more times, the primary key number is now up to #5. Let's say I add records to number 5.
OK, now I go back to my associated table and look inside it, and it has the following:
1 all data
2 all data
5 all data
** record 2 and 3 don't exist.
Is there a line of code I can use that would prevent this? Is so, where would I put it? Would I put it in my GetKey program?
I would like to have the form/table recognize I am at the last form with data and not let me go past that form w/o putting data into it so I can keep things "tight"
Thanks
jason
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only