>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
Your primary key would be batch_num+ve_num
>
>Linda