<div>Hi <font size="2"><span style="background-color:rgba(255,255,255,0)">Stacey!<span></span></span></font></div><div><br></div>You can add primary key, consist of first 3 fields or use SQL to implement needed changes (as I did). <div>I do not know if it deliberate.</div><div><div><br>Stacey Johnson [via vtiger CRM] wrote:<br><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div>phpmyadmin says: "This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available"<br></div>Is it deliberate to not add primary key to this table?<br><br></div>Stacey<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Aug 31, 2015 at 10:11 PM, Oleg <span dir="ltr"><<a href="http:///user/SendEmail.jtp?type=node&node=17213&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>></span> wrote:<br><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' style="border-left:2px solid #cccccc;padding:0 1em" class="gmail_quote">Hi!<br>
<br>
This is possible. Relations 1:m between modules are determined by records in<br>
/vtiger_fieldmodulerel/ table. There are fields [fieldid, module, relmodule,<br>
status, sequence]. In order to create two relation you should create two<br>
fields (UI type 10) in SalesOrder module and add two records to<br>
/vtiger_fieldmodulerel/ table like<br>
<br>
[fieldid], SalesOrder, Accounts, null, null<br>
<br>
Where [fieldid] you should get from /vtiger_field/ table.<br>
<br>
Alternatively, you can try to create in SalesOrder module one more field<br>
UiType 73, which corresponds to mandatory field for Account selection, or<br>
UiType 68, which corresponds to field for Contact or Account selection.<br>
<br>
<br>
Preexo wrote<br>
<span>> Has anyone ever managed to get more than one relationship of the same<br>
> kind?<br>
> So for example I would like to have two Organization (Accounts) fields in<br>
> the SalesOrder.<br>
> Anyone ever done that? Seems like vtiger has some trouble if more than one<br>
> field exists with the same relationship.<br>
<br>
<br>
<br>
<br>
<br>
</span>--<br>
View this message in context: <a href="http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17206.html" rel="nofollow" link="external" target="_blank">http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17206.html</a><br>
<div><div>Sent from the vtigercrm-developers mailing list archive at Nabble.com.<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="nofollow" link="external" target="_blank">http://www.vtiger.com/</a><br>
</div></div></blockquote></div><br></div>
<br>_______________________________________________
<br><a href="http://www.vtiger.com/" rel="nofollow" link="external" target="_blank">http://www.vtiger.com/</a>
<br>
<br>
<hr noshade size="1" color="#cccccc">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17213.html" target="_blank" rel="nofollow" link="external">http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17213.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from [Vtigercrm-developers] Relating tickets with projects without using Related list, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://vtiger-crm.2324883.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></blockquote></div></div><br><br>-- <br><div dir="ltr"><div>--</div><div>С уважением, руководитель веб-студии PIN<br>Антонов Олег.<div>+7-921-922-91-91</div><div><br></div><div><a href="http://pinstudio.ru/" target="_blank" rel="nofollow" link="external">http://pinstudio.ru</a></div><div><font color="#999999">- Создание и продвижение сайтов</font></div><div><font color="#999999">- Автоматизация бизнеса</font></div><div><font color="#999999">- Увеличение продаж</font></div><div><br></div></div></div><br>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17214.html">Re: [Vtigercrm-developers] Relating tickets with projects without using Related list</a><br/>
Sent from the <a href="http://vtiger-crm.2324883.n4.nabble.com/vtigercrm-developers-f4.html">vtigercrm-developers mailing list archive</a> at Nabble.com.<br/>