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

[Oleg]

Hi Stacey!

You can add primary key, consist of first 3 fields or use SQL to implement
needed changes (as I did).
I do not know if it deliberate.

Stacey Johnson [via vtiger CRM] wrote:

> phpmyadmin says: "This table does not contain a unique column. Grid edit,
> checkbox, Edit, Copy and Delete features are not available"
> Is it deliberate to not add primary key to this table?
>
> Stacey
>
> On Mon, Aug 31, 2015 at 10:11 PM, Oleg <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=17213&i=0>> wrote:
>
>> 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.
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17213.html
> To unsubscribe from [Vtigercrm-developers] Relating tickets with projects
> without using Related list, click here
> <http://vtiger-crm.2324883.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=17192&code=T2xlZy5hQHBpbnN0dWRpby5ydXwxNzE5MnwyMTg4NjE0MTY=>
> .
> NAML
> <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>
>


-- 
--
С уважением, руководитель веб-студии PIN
Антонов Олег.
+7-921-922-91-91

http://pinstudio.ru
- Создание и продвижение сайтов
- Автоматизация бизнеса
- Увеличение продаж




--
View this message in context: http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Relating-tickets-with-projects-without-using-Related-list-tp17192p17214.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150901/6483e64e/attachment.html>