Hi, i needed to have a unigue number in the opportunities module. After searching the forum and google ive found that i can add a int field to mysql with auto increment - ive done this on a test table and it worked fines however the auto increament needs to be the primary key for the table,

Is there another way so i dont have to play with the relashionships/keys of the opportunities table??

I thought maybe using an another table and a trigger? or is there a better way?

Many thanks for your time and help

Andy

PS i dont know if this makes much difference but its sugar 4.5.0c and mySQL 5.0.24 on a windows 2000 server