Custom Module - relate problems

[guptajee]

I created a custom module, and then created Custom fields for that module. Some of the custom fields were 'related' to contacts, since I want 4 contacts to appear in my Custom module. Contact 1 relates fine to my custom module, but I am getting an error 'No match for field: " when I try to click save. Anyone knows what's going on?

[eosterberg]

Have you found a solution to this issue yet?

[eosterberg]

Ok, I found the solution to my problem.

SugarCRM needs both a varchar(36) field and a varchar(255) field in the table named [module_name]_cstm
It appears that only the varchar(255) is created for the second and each additional relationship between the same module to module link. If you could provide the specific details of what you are adding or linking I can provide some more specific answers.

The same issue, missing the second db record for each relationship added between like modules after the first, is going on with the table fields_meta_data.
If you can find the LBL_LIST_RELATED_TO record and duplicate that as needed for each additional relationship making sure that the 'id' and 'name' are uniq for each pair.
You will also need to edit the related record of "'type'='relate'" to match the uniq name for the "'type'='id'".

I feel like I'm talking in circles...
I know this is confusing, It took me forever of reading and re-reading all I could find on this issue.

Check out these other related posts.
http://www.sugarcrm.com/forums/showthread.php?t=34255
http://www.sugarcrm.com/forums/showthread.php?t=34219
http://www.sugarcrm.com/forums/showthread.php?t=27917

Hope this saves someone else a few days... I've been at this for 3 days!
Maybe someone will release docs that describe this relationship for 5.0?!
Looks like section 3.5 might have helped me in this yet unreleased doc. http://developers.sugarcrm.com/wordp...elopers-guide/ Clint are you reading this?