I have two tables related one-to-many. Is there anyway i can represent the order/suborder as 10000-A, 10000-B rather than using the suborder id like 10000-1259?

In other words can i convert suborders that are number such as 1234, 1244, 1355 as A, B, C?

I hope i have not totaly confused everyone like i have myself!!

Doh!!

It depends what you are trying to achieve. If the A, B, C represents a particular group of suborder eg type of product then yes it is possible. If you want simply to replace the autonumber ID with a text string, I'm sure it is possible but I think it would take a bit coding (understatement I think)

HTH