Can't add related module block to the main layout

[joebordes]

this query will show you the list of related modules for Accounts

Code:

select *
from vtiger_relatedlists
left join vtiger_tab on vtiger_relatedlists.related_tabid = vtiger_tab.tabid and vtiger_tab.presence = 0
where vtiger_relatedlists.tabid = 6 order by sequence

this query will show you the existing related blocks that you have in the accounts module

Code:

SELECT vtiger_tab.name
FROM vtiger_blocks
INNER JOIN vtiger_relatedlists ON vtiger_blocks.isrelatedlist=vtiger_relatedlists.relation_id
INNER JOIN vtiger_tab ON vtiger_relatedlists.related_tabid = vtiger_tab.tabid
WHERE vtiger_relatedlists.tabid = 6

the difference between the two is what is being shown in the layout editor "Add Block" picklist 

share the results with us