Topic: Unique line ID
I'm looking to create a unique line ID for use in time-tracking application, but I'm scratching my head as to how I would go about this.
So far, I've tried reserving a variable and then just incrementing it by one with each entry and saving the new value, but that doesn't work because the variable is reset as soon as the call is gone. This would also work if I could pick the value back up again by querying the table where it was stored, but I don't know how I'd do this dynamically (since more than 1 employee would be logging in).
Next, I tried a cobination of creating a seperate table of entry IDs and then queried the table for "entryID > " (leaving the operand blank, in hopes that it would just find the largest number) and then getting the stack properties for the entry ID table, incrementing by one, and then putting the new value back in, but this only appears to work up to entry ID 10. So it must be grabbing all 10.
In a nutshell, I'm not sure how to specify tblEntryID so that I can grab the stack properties and count the rows. If I just use stack properties alone, there's no way to specify which stack it's looking at...right?
I'm sure there's gotta be some sort of creative solution out there, but my brain is numb at the moment and it's time to go home.
Any helpful input would be much appreciated.
Cheers,
Tim G.