Case module modified

[hoang]

hi experts,
I'm importing our Access db to Cases modules. i'll need to create extra fields and use our own autonumber instead of the case_number. I've tried adding in a field through Sugar, changed the attribute to the same attributes with case_number through phpmyadmin , added that field to edit layout in Sugar.
When i create a new case, this field doesnt increment automatically as expected. How do i
1. make this field auto increment in Sugar? As It is required field, do i have to grey out the textbox like case_number? how do i do that in php?
2. is there any document or link for Sugar-5 file structure? I look at thoses php files but they are kept in different places from the document for Sugar 4.5

Thank you for you reply
Cheers

Windows 2k
SugarCRM CE-Full-Version 5
Xammp 1.6.3a

[andopes]

HI, hoang

I believe it could exists only one auto_increment in a table.
Then you could create a custom vardefs for Cases and disable the autoincrement property for case_number and repair database.
Create your new field.

You could access a lot of documentation regarding Sugar structure at www.sugarcrm.com/wiki

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[hoang]

thank you Andre' !!
Just realized i missed out one important information in my initial post. I actually created an equivalent field with case_number using Studio so it is in case_cstm table. Since you say there could be only one autonumber in a table, it is ok to have a customised autonumber in "case_cstm" table and not in "cases" table right?

Allow me to go through again..
I use Sugar Studio to create the additional field called CC. I then used phpmyadmin to change its attributes to the same attributes of case_number. Now CC is an autonumber and required field. Finally, I added this CC field in edit layout in Sugar.
I now try to create a new case but it still didnt increment in CC field.

I added this for the customised field
'type' => 'readonly',
'displayParams' =>
array (
'required' => true,
),
in editviewvardefs.php in custom\modules\Cases\metadata and custome\working\modules\Cases\metadat but it didnt work as well.

Please help
thank you
& appreciate