Numbering

[boxster]

How can such a numbering as below can be implemented?

yy being the last 2 digits of the year,

yy-0-01, yy-0-02, ..., up to yy-0-10 then
yy-1-01, yy-1-02, ..., up to yy-1-10
etc.

Thank you!

 

[namliam]

You realize your limmiting yourself to 100 "key values" ?

To implement your own PK, search the forum I think there are a few samples out there... I have never done it myself....

Regards

The Mailman

 

[boxster]

I'll try to look for it. Well, the limit is now 100, but I'll add one more digit if necessary. Thanks for the warning

 

[namliam]

When using fixed PK values like this stay fixed dont change it....

Make sure you have a fitting format...

If you are not sure, use an autonumber as your 'real' but invisible to the user PK.

Also if that would seem better you can make a compound key existing of 2 or 3 fields...

Regards