[Vtigercrm-developers] Relating tickets with projects without using Related list

[Oleg]

Hi!

This is possible. Relations 1:m between modules are determined by records in
/vtiger_fieldmodulerel/ table. There are fields [fieldid, module, relmodule,
status, sequence]. In order to create two relation you should create two
fields (UI type 10) in SalesOrder module and add two records to
/vtiger_fieldmodulerel/ table like

[fieldid], SalesOrder, Accounts, null, null

Where  [fieldid] you should get from /vtiger_field/ table.

Alternatively, you can try to create in SalesOrder module one more field
UiType 73, which corresponds to mandatory field for Account selection, or
UiType 68, which corresponds to field for Contact or Account selection.


Preexo wrote
> Has anyone ever managed to get more than one relationship of the same
> kind?
> So for example I would like to have two Organization (Accounts) fields in
> the SalesOrder.
> Anyone ever done that? Seems like vtiger has some trouble if more than one
> field exists with the same relationship.





--
View this message in context: http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17206.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.