Lasso and FMP's internal record id's

[charper]

We're using lasso to create records in an FMP 4.1 database from our website. When a website user (customer) places an order on our website, our lasso code creates a new order record in our database. The problem we're having is that periodically (almost randomly) the FMP database starts using rediculously high record id's when it creates new records. I'm referring to FMP's internally stored record ids. For example, the database's last record id might be 20,253. Then someone places an order on the website and the next record id FMP generates is like 14,299,382!! Why is ity doing this? Is this a lasso bug?

[Anatoli]

That is from FM. The intarnal are like that. You can use yor own series of numbers with autoenter

[flexistentialism]

as above..........use the autoenter serial no and start from whatever you want. RecordID must not be used as a way to reference records permanently. If you were to close the database restart FMPro open the database again you may find the ID's have changed! although no record will have the same one (thats why it's required for updating, deleting etc..) it can change.

Use a "key" indexed field with an autoenter serial number

[charper]

Thank you. That's always what I've wanted to do but for some reason our web developer has been under some illusion that we have to use FM's internally stored record id in order for the lasso driven shopping cart on our website to work. We're discussing it now. I think he just had some bad information.