Missing serial numbers
Hello once again,
I have a script to import student information from either a CSV or XLS file in my database. As an example I have both files setup with one record in each file. When I import them, I get hundreds of blank records, assuming they are from blank rows in the XLS file, so I made one of the fields in the database require a last name. That solved the blank records. But the serial numbers still increase by over one hundred instead of one. I had the serial numbers generation on record creation, so I thought switching them to 'On Commit' would solve it but it doesn't.
Am I missing something. I guess it isn't a big deal since the numbers are still unique. I just don't want to have problems later on....