How do i relate data in a newly developed module

[stephen_ari]

I'm using version 5.0d. I created a new module using the module builder and related it to leads and contacts. I can create a new lead and enter data into the new module, but when I convert that lead to a contact the data does not appear in the mopdule for the contact. What am I missing?

Thank you

[DragonflyMaster]

Have you read this wiki on creating relationships between modules?

[MDSPaul]

I'm working for stephen_ari on the above problem, but I run into the following problem.

Whenever I try to repair the database using the above directions, it never seems to finish. It stalls on

Repair Database

Processing database and vardef comparison...

I just can't get past the very first repair for the first file. I go admin - repair. Any idea why?
The package was named Creditor, the module name CR_Account. When installed, I see a folder credi_CR_Account in the sugar directory. I'm not sure precisely what to put for the module name, since I would have assumed the name in the module builder would have matched the directory name for the module. The field name is test_relate_lead, i tried just that for the key as well as test_relate_lead_c for the rhs_key

Looking in the module builder, there were some existing relationships. Didn't work. Deleting those relationships and the relationship field and starting over didn't help.

My most recent attempt of many:

<?php
$dictionary['Leads']['relationships']['Leads_CR_Account'] = array( 
'lhs_module' => 'Leads', 
'lhs_table' => 'Leads', 
'lhs_key' => 'id', 
'rhs_module' => 'CR_Account',
'rhs_table' => 'CR_Account_cstm', // must use custom table as we're using a custom Relate field in step 4
'rhs_key' => 'test_relate_lead_c', // must match the name of the field containing the PARENT id in the CHILD_cstm table
'relationship_type' => 'one-to-many' // one LHS to many RHS
);

$dictionary['Leads']['fields']['lead_relate'] = array ( 
'name' => '<test_relate_lead>', 
'type' => 'link', 
'relationship' => 'Leads_CR_Account', 
'source'=>'non-db', 
'vname'=>'lbl_test_relate_lead', 
);
*<LBL_FIELD_LABEL> can be anything you want, but it must match the key you use in the language file later on
?>

[DragonflyMaster]

Hi,
I guess you copied the code from the wiki and put it by hand in the php files...
At a first glance, there is at least one error, that is this line in your code:

*<LBL_FIELD_LABEL> can be anything you want, but it must match the key you use in the language file later on

Delete it, save and try repairing again.