How to avoid mistakes in a database? Please help

[tooold]

1. I have two (2) fields: Order_Code (number) and subOrder_Code (text). In a way, users would make input on both fields and at the latter stage, these 2 field would combine together for the records. My problem is: how can I make it to avoid repeating of the 2 fields? For example:Order_Number: 1000, subOrder_Number: b. Questions: How can I joint it to become: 1000b, and this kind of order cannot be repeated?

2. Originally, I want to make an incremental value by 1 for the Order_Code, which was text rather than number, so on frmOrder, onload, I put these codes:
[code] Me.Order_Code = Nz(DMax("val([Order_Code])", "[Orders]"), 0) + 1 [code]
But the damn thing doen't work, stoped at 1000.


Quetion: Is there any way to fix this (combination of numbers and letters, increasing by 1 and not reaping)?
Thanks for all helps

[pbaldy]

It sounds like the data type of that field is text. Is this homework or are you cross posting, since this post is hauntingly similar to another?

[tooold]

Paul,

Just cross posting. Sorry. But I got stucked with the problem for two days already. The shop just been set up and running sir, orders are comming in need to solve the issue real quick

[pbaldy]

Then you already know that the cause of this issue is the data type. Change it to a numeric data type.

[tooold]

Yes sir. I did just that. But still stucked with problem: how can i join the two field together and make sure they will not repeat each other during the data input