Indexes and auto-generated IDs
Hey Andy, hope the online development is going well, we'll be needing that! ;)
I see that tables like the customer and notes tables etc don't have auto-incremented primary keys - so are you generating the next ID (eg, when creating a new customer) within the application? Can this value be reset? - at the moment, in my test db it's creating customers starting at something like 1168, whereas I'd like to look at the feasibility of starting at 1 etc.
Even if I nuke the records in the lastid and lastid2 tables, RGP is still generating ID's from a persistent internal variable. Resetting the auto-increments in the various indexes has no effect on the behaviour.
(Yes, I know this is hacking a bit on a test db, I'm just looking into RGP's behaviour and the feasibility of implementing something as RGP doesn't have a concept of a public membership number, which my client currently requires.)