Hi To all,

I'm a new user of Saleslogix ver 7, i wonder if you can guide me on how to create custom table id (6 digits) with a format like this (000-000)..

thank you in advance.

A table ID is a table ID. You don't want to change that. It is only meant to identify a record in the database, nothing more. If you're wanting to have some value in the format of something like 000-000 you should create this as a separate field. Then you can create code to populate that how ever you'd like. Make sense?

Thanks Ryan for your prompt response. 

Yeah, an ID or Code for example i create new account with data fields accountID accountName, address and so on.. i want to create a special code or ID to identify that this code is belong to this Accountname or accountID.. i know accountID is already given.. however, i need a code or for my datafield i called it codeID.. just a simple function or coding for this one will appreciate.

Do you have any remote users or offices? This would complicate the way in which this problem is solved.

Is it a numeric code that you are looking for? 000-001, 000-002 etc, or can it contain characters? We may be able to derive something suitable from the AccountID if it can contain characters and there are no remotes.

What is the purpose of the hyphen at char 4? Does it denote a logical break of some sort?

no we don't have remote users or offices.. actually an ID 000001 will do.. without hyphen.. thanks for the response

Can it be purely numeric (1, 2, 3 etc) or do you need the leading zeros (000001, 000002, ...)?

yes i need with the leading zeros.. is it possible? thanks..