Display and search info from module b in module a.

[pixprotom]

I have a custom field in the Accounts module (membership - yes or no). I need to show this membership field in the Contacts module and also be able to search for all contacts whose account is membership = yes.

Are there any good clear instructions around that I can follow to get this to work? Or can someone guide me through this?

[raylcm]

Hi, Is there anyone who can help reply this post? I have the same need and cannot find any ugrade-safe and workable solution after 2 days search

[eitrix]

Well if i got you right, you want to have contact assigned to account and if that account is membership = yes, you want to see that on contact also?

I would do it with logic hooks by making a custom field in contacts module also named like membership and have it displayed on detailview only, but then i would make before_save logic hook which would do something like this:

 // find out if the account from contact has membership yes or no
$query = "SELECT membership FROM accounts WHERE id = '$bean->account_id'";
$result = $db->query($query,true);

// fetch a row selected
$row = $db->fetchByAssoc($result);

// assign account membership status to contact,  do log->fatal to see what array field to use
$bean->membership = $row['membership'];

// now you will have membership status copied from account to contact, but you can also make
// before_save logic_hook for account to update all contacts assigned membership status so you are 
// allways up-to-date