<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">Yes, we did exactly this recently, and the M:M relationship is hard-coded in to a few locations which means that just adding a normal 1:M relation field and related list don't immediately work!</div><div class="gmail_default" style="font-family:verdana,sans-serif">In /modules/HelpDesk/models/Module.php getQueryByModuleField() had to remove the ServiceContracts module from the array.<br>In /modules/ServiceContracts/models/Module.php getQueryByModuleField() - we simply removed this function.</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><p style="font-size:12.8px;color:rgb(80,0,80)"><span style="color:navy;font-family:Verdana,sans-serif;font-size:10pt">Martin Allen</span></p><p style="font-size:12.8px;color:rgb(80,0,80)"><b style="font-size:12.8px"><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)">01392 248692 - Main Office<br>01392 690659 - Direct Line</span></b><br></p><p style="font-size:12.8px;color:rgb(80,0,80)"><b><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)"><img width="288" height="65" src="cid:image001.png@01CFC1D6.1BCFF790" alt="signature2"></span></b><span style="color:rgb(31,73,125)"></span></p><p style="font-size:12.8px;color:rgb(80,0,80)"><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:navy">Have you visited our website recently? <a href="http://www.clystnet.com/" style="color:rgb(17,85,204)" target="_blank">http://www.clystnet.com</a></span><span style="color:rgb(31,73,125)"></span></p><p style="font-size:12.8px;color:rgb(80,0,80)"><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:navy"><br></span><span lang="EN-US" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(153,153,153)">The information in this email is confidential If you are not the intended recipient, you must not read or use that information. This email and any attachments are believed to be virus free however no responsibility is accepted by Clystnet for any loss or damage arising in any way from receipt or use thereof. Clystnet Ltd (company reg number 7164503) is based at Silverdown Park, Fair Oak Close, Clyst Honiton, EX5 2UX</span></p></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 12 Oct 2020 at 14:38, Ing. Matus Sopko <<a href="mailto:sopko@its4you.sk">sopko@its4you.sk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<tt>The current relation between Tickets and ServiceContracts is
N:M.<br>
What is the goal of this relation? We don't have any Tickets
related to two ServiceContract for now.<br>
In our cases, this relation makes only problems.<br>
I want to change this relation to 1:N (popup ServiceContrat in
Ticket module)<br>
In this case, the support team can choose the correct service
contract in the create/edit view and of course related Ticket for
ServiceContract.<br>
I know that we have to change the calculation of Used Units in
ServiceContract module and rebuilt saved relations.<br>
Do you see any other issues? </tt><tt><span><tt><br>
</tt></span></tt>
<pre cols="72">--
S pozdravom / Best regards / Mit freundlichen Grüßen
Ing. Matus SOPKO
IT-Solutions4You s.r.o.
Kancelária: Slovenská 69
Sídlo: Frantiskanske nam.5
080 01 Prešov
SLOVAKIA
Tel./ Fax +421/ 51/ 7732370
email: <a href="mailto:sopko@its4you.sk" target="_blank">sopko@its4you.sk</a>
<a href="http://www.its4you.sk" target="_blank">http://www.its4you.sk</a>
skype: matussopko</pre>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div>