StupidStudent
Registered User.
- Local time
- Today, 17:31
- Joined
- Mar 12, 2007
- Messages
- 29
Hi all fisrtly Wicked forum loads of great info!!
I was wondering if anyone could help me i am new to databases and have managed to cobal together something for a uni project however i have hit a wall.
I have a supplier order form which has a txt box called SuppOrderNum which is the primary key. I wanted this to be "SO1" and then "SO2" and so on. (This is due to not being allowed to use auto number??) Would anyone know an easy way to do this PLEASE !! I have looked every where bt have no idea what to look for

THANKS
I was wondering if anyone could help me i am new to databases and have managed to cobal together something for a uni project however i have hit a wall.
I have a supplier order form which has a txt box called SuppOrderNum which is the primary key. I wanted this to be "SO1" and then "SO2" and so on. (This is due to not being allowed to use auto number??) Would anyone know an easy way to do this PLEASE !! I have looked every where bt have no idea what to look for

THANKS