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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only