URgent help

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

Light Poster

28 posts since Jan 2005

Reputation Points: 11

Solved Threads: 1

A Table, as in, an access database?

Taboo Programmer

Team Colleague

2,910 posts since Dec 2004

Reputation Points: 361

Solved Threads: 215

This article has been dead for over three months

You