creating record id as per value list

[Deepak Kumar]

I want to create different record id as per my valuelist:

ex.- i have parts and products in valuelist.

If i select parts...then...in id field ,after clicking on button, a record id parts_01 should be generated

and when i select product...then...in id field ,after clicking on button, a record id product_01 should be generated.

After a new record, parts should generate parts_02 and for product, it should generate product_02.

please help in a script test.

[Deepak Kumar]

is there any solution for this..?

if it's there pls reply.

[bcooney]

imho, what you're asking for doesn't really make much sense, and perhaps that's why you're not getting any replies.

What's the difference between a part and a product?

Are you aware that a calculated ID is not the best way to go. IDs should be meaningless, auto-entered serial numbers or UUID.

Please describe the tables that you have and the context of your question.

btw: please rethink your skill level rating.

[comment]

Usually, when you get no replies it's because the question isn't clear enough - IMHO, this is no exception.

Perhaps you mean something similar to:

http://fmforums.com/forum/topic/73473-serial-increment-a-child-record/