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

Stacey Johnson stacey.johnson110 at gmail.com
Tue Sep 1 09:30:27 GMT 2015


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 <Oleg.a at pinstudio.ru> 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150901/93f803c9/attachment.html>


More information about the vtigercrm-developers mailing list