How do I insert a data in a sub-table of a module? for example I have this module: MainModule it's table is mainmodule, and the module's sub-table is mainmodule_sub.
so I wanna know how to insert a data into mainmodule_sub using SugarBean.
For a clearer view:
the problem is most of the modules only have the main_tables and _cstm tables, and not all modules have one or two tables; so I just wanna know how to insert data into the third_table let's say for example the ProspectLists module and it has this 5 tables namely prospect_lists, prospect_lists_cstm, prospect_lists_prospect, prospect_lists_campaign, and so on..
how do I insert the data into prospect_lists_prospect?
As I have been through asking question from Stack to the Developers, and as of now it's either you create your own API for it to be done or make your own local call/insertion via SQL because only the main_tables and _cstm tables are connected to each ModuleAPI.