VTModuleDesigner
VTModuleDesigner copied to clipboard
vtiger 6.1 - crmentity-crmentityrel tables issue
Hi! First of all thanks for this good work. I started some days ago my first experience with Vtiger. ..and soon i needed this module designer.
I'm working with vtiger 6.1.
I have installed moduledesigner-10102014 and the patch.
This module have several minor bugs related to fields properties( lost when I edit my module), but this helped me to understand how vtiger work, his database tables ...how to fix this properties manually through vtiger_fields table.
I tried create a identifier field in my module type auto increment ... not work ..but this is not a big problem (there is always a automatic identifier created).
I have a field ui type 10 and I have understand how setup relation manually using setRelatedModules
Only one problem I can't solve : My module is a easy list of payments related to the accounts. So if I add a payment from accounts -> payments->quick create ..all go well, vitger update all related tables crementity and crmentityrel. If I open payment from the menu and add a record, only crmentity are updated .. nothing on crmentityrel table. I'm a noob, I tried to search here but I haven't found a solution that i can't understand. Can someone help me with some suggestions ?
Thanks in advance !
Hi @berusnet !
Welcome in the Vtiger Community and thanks for using Module Designer! Vtiger use 2 big types of related list : 1..n (get_dependents_list) and n..n (get_related_list) associations. vtiger_crmentityrel table is only used with n..n assocations. For 1..n associations it is automatic, vtiger looks through UIType 10 fields.
Regards, Jonathan