AnsweredAssumed Answered

Unique serial number

Question asked by PeterO'Toole1697 on Feb 1, 2012
Latest reply on Feb 2, 2012 by philmodjunk

Title

Unique serial number

Post

 

Hi

I am new to this forum and Filemaker so bear with my ignorance. Only started working with Filemaker last Friday!!

I have created a table with fields and a layout. I addded a field to generate a unique serial number which was fine and it increments with each new record. The problem is, when I delete a record and lets say that record was serial number "2" as the next record would naturally be serial number "3" if I then create a new record it skips serial number "3" and adds "4". Am I doing something something wrong or is that just the way it works.

Maybe it doesn't matter as I presume everything still has a unique serial number.

ALSO!! Is there a way that after I have entered my data on my Layout to set the fields to clear as it's very easy to overwrite the data you have just entered?

I know I should be trying to figure this out, I have tried, as I am only new to it but boss has thrown me in at the deep end and under pressure.

thanks in advance for any help. 

cheers

Peter

Outcomes