0

Hi everyone

I have a table with 3 columns

pk_itm_code
name
fk_code

The pk_itm_code is taken from another master table. Now my requirement is automatic generation of fk_code

fk_code = pk_itm_code + "PT" + random generated no. (startin from 1)

If the user selects same pk_itm_code 2 times then the fk_code will be

(pk_tim_code)PT1
(pk_tim_code)PT2

Once he selects the other pk_itm_code it should again start with 1 and not 3

I hope u got my problem

Please help me

Thanks

2
Contributors
1
Reply
2
Views
12 Years
Discussion Span
Last Post by Comatose
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.