Created Custom Module

[Barakanooz]

I created a custom module (Licenses) by coping the Oppertunities module and then performing a rename to rename everything from Oppertunity to License. I created the mySQL tables and have created the required files to have it work. Everything is working execpt I have an Account Name: field with the Select button (just like the Opportunities module). But for some reason I cant get the value to save.

I can hit the select button get the popup to select the Account Name, select the Account Name, then when I go to save the form the Account Name doesn't save. If someone could describe how the value is saved ( files called, variables traced ) I would greatly appreciate it. I have been trying to trace through to find out what I am missing but haven't been able to find it. If I can get this to work I will be posting a very detailed document on how to created a custom module.

Thanks,

[Barakanooz]

Got it working. I found that I had problems with the 'id' values in the DB. When I imported a bunch of data from ACT the id field was filled but the value was something like (square)4657474757457475 ... not sure if the (square) was a return value or what.. But when I used a function and a trigger to create new id values for each row as it was imported then the process of clicking the Select button, picking the account, and saving the form works.

The only problem now is since I had to create new ids from scratch I have to take those new ids and remap everything, so the related notes, contacts, etc.. point to the right account.

The function and trigger I used are from this post
http://www.sugarcrm.com/forums/arch...php/t-2895.html