Richard,<br><br><blockquote style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;" class="gmail_quote">Also, can anyone tell me why helpdesk items are connected to themselves<br>
in the aforementioned table and more importantly, if I must also do this<br>
with my new tickets?<br></blockquote>
Im not sure about this, why do you say that tickets are related to themselves?<br><br><blockquote style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;" class="gmail_quote"> how the connection is made between a ticket and an account<br>
</blockquote><div>As far as the relation is concerned, its stored in the vtiger_troubletickets parent_id column.<br></div><br><div class="gmail_quote">On 16 September 2011 07:59, Richard Hills - TechnologyWise <span dir="ltr"><<a href="mailto:richard@tw.co.nz">richard@tw.co.nz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I am wanting to create tickets using a custom script which will import<br>
data out of a similar item.<br>
<br>
Currently I am confused as to how the connection is made between a<br>
ticket and an account, I have looked in the table vtiger_crmentityrel<br>
and noticed that helpdesk items are always related only to themselves here.<br>
<br>
Can anyone give me the right location to make this coupling?<br>
<br>
Also, can anyone tell me why helpdesk items are connected to themselves<br>
in the aforementioned table and more importantly, if I must also do this<br>
with my new tickets?<br>
<br>
Thank you.<br>
<br>
--<br>
Richard Hills<br>
TechnologyWise Ltd, Tauranga, NZ<br>
<a href="mailto:richard@tw.co.nz">richard@tw.co.nz</a><br>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a><br>
ph: +64 (0)7 571 1060<br>
fax: +64 (0)7 571 1061<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Vikas<br>Vtiger Team<br>