Hi,

I have a table as following:
Table name: VEHICLE
FIELDS: batch_num (primary key)
ve_num (primary key)
price
order_date

when I create the table, i encounter a problem is that i cannot set both batch_num and ve_num as primary key. Then I set batch_num is primary, ve_num is candidate. However, i still cannot save the following two records:

batch_num ve_num price order_date
0000001 b11111 10,000 01/01/2002
0000001 c11111 11,000 02/02/2002

the error message is: uniqueness of index batch_num is violated. How can I solve the problem. thanks

Linda