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.

is there any solution for this..?

if it's there pls reply.

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.

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/