Subpanel doesn't link to parent record

[jmugauri]

Hi, again

I've successfully managed to make my custom subpanel (AccountSLAs) show in the Accounts detail view. Thing is, my 'quick create' and 'full form' in the subpanel do not automatically populate the related fields from the parent Accounts view (i.e. populate akkn_account and sla_account_name with accounts.id and accounts.name, respectively). I have, thus far, done the following:

1. Edited layout_defs.php and vardefs.php in the Accounts module to account for the relationship
2. Likewise, edited vardefs.php in AccountSLAs module
3. edited AccountSLA.php (bean file) to extend fill_in_additional_detail_fields() thus:

$query = "SELECT acc.id, acc.name FROM accounts AS acc, accountslas AS acc_sla WHERE acc.id=acc_sla.akkn_account AND acc_sla.id='$this->id' AND acc.dele\
ted=0";
$result = $this->db->query($query, true, "Error filling in additional detail fields");
$row = $this->db->fetchByAssoc($result);
if ($row != null) {
$this->sla_account_name = $row['name'];
$this->akkn_account = $row['id'];
} else {
$this->sla_account_name = '';
$this->akkn_account = '';
}

What am I missing?

[gunni]

Dont you think one thread is enough?

[jmugauri]

Suppose it would be under normal circumstances. I encourage anyone who can to delete the post in the developers' forum.

However, more to the point, Do u actually know anything I can do, or are you more concerned with forum politics? I forsook niceties when i realised at least one of the scores who read my post could provide valuable insight in a line or two, if they cared to, but obviously can't be bothered to do anything but (as you've demonstrated) moan about the (im)propriety of my methods without empathy.

Here's the appropriate context... am desperately in need of a hand from anyone who has a clue. A link to a comprehensive subpanel how-to (not the insufficient ones in the Sugar Docs or the wiki) would be a reasonable start, don't you think?

[gunni]

Sorry i forgot to mention, that i am not able to help with your problem.
If a solution comes to my mind i will post it here.

[jmugauri]

Finally sorted, people!

For any who may run into similar problems, ensure you custom module vardefs.php defines both an id and name field with the correct array fields and field type (i.e. link/relate as required)...

Then ensure your custom bean has all required fields defined in the get_list_view_data function. Use existing modules e.g. Cases as a reference

Otherwise, follow the instructions in this post.

Good luck!!