6/18/2025 10:30:23 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Lookup Restrictions
Posted: 21 Jun 07 8:31 AM
|
Hi,
I've had a look on the forum and I've noticed Ryan wrote a document about restricting lookups, but I'm still having problems with a specific lookup. I've got a field that stores a userid and a lookup box used to store the data. I only want it to return a list of users with a specific title. I'm using the following:
FormatType ftUser
LookupMainTable USERINFO
LookupMode lmUser
LookupRestrictAlways True
LookupRestrictField TITLE
LookupRestrictOp <br><br>Now this works if I change the lookupmode to lmTable but not when it's set to lmUser which I need to it be <img src="/images/forumimages/smiley_frown.gif" align=absmiddle border=0 \> All help appreciated!</td>
</tr><tr>
<td><table border="0" cellpadding="0" cellspacing="0" width="100%" class="Normal">
<tr>
<td align="Left">[<a href="/forum.aspx?forumid=2000&postid=8729&forumaction=reply">Reply</a>][<a href="/forum.aspx?forumid=2000&postid=8729&forumaction=quote">Quote</a>]</td><td align="Right"></td>
</tr>
</table></td>
</tr>
</table></td></td>
</tr><tr height="25">
<td colspan="2"><table cellspacing="0" cellpadding="0" border="0" width="100%">
<tr>
<td align="left" width="50%" class="Normal"><b> Page 1 of 1</b></td><td align="right" width="50%" class="Normal"> </td>
</tr>
</table></td>
</tr>
</table>
<span class="ForumSmallerFont" style="FONT-STYLE: italic">You can
subscribe to receive a daily forum digest in your <a href="/page.aspx?action=profile">
user profile</a>. View the site <a href="/page.aspx?action=codeofconduct">code
of conduct</a> for posting guidelines.</span><br>
<br>
<table width="100%">
<tr>
<td width="100%" class="featurebox">
<table><tr><td valign=middle> <b><a href="/forumrss.aspx" target=_blank><img src="/images/xml.gif" border=0 align=absmiddle> Forum RSS Feed</a></b> - <i>Subscribe to the forum RSS feed to keep on top of the latest forum activity!</i>
</td></tr></table>
</td>
<td> </td>
</tr>
</table>
<br>
</td>
<TD> </TD>
</tr>
</TABLE>
<!-- FORUMS END --></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</TD>
</TR>
<tr>
<td class="tablebox">
<!-- PAGE FOOTER BEGIN -->
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td width="*"><span class="copy"> slxdeveloper.com is brought to you courtesy of <A href="page.aspx?action=viewuser&qid=1">
Ryan Farley</A> & <a href="http://www.customerfx.com/" target="_blank">Customer
FX Corporation</a>.<br>
This site, and all contents herein, are Copyright ©
2025
Customer FX Corporation. The information and opinions expressed here are
not endorsed by Sage Software.</span></td>
<td width="150" valign="top">
<span class="copy">
<br>
<a href="/page.aspx?action=codeofconduct">code of conduct</a> | <a href="articlerss.aspx" target="_blank"><img src="images/xml.gif" border="0" align="absMiddle" alt="Subscribe to the slxdeveloper.com Latest Article RSS feed"></a></span> </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<!-- PAGE FOOTER END --></td>
</tr>
</table>
<span class="copy" style="COLOR: #e5e5e5">page cache (param):
6/18/2025 11:02:33 PM
</span>
<!-- Start of StatCounter Code -->
<script type="text/javascript" language="javascript">
var sc_project=724140;
var sc_partition=6;
var sc_security="0fc5f449";
</script>
<script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/counter.js"></script>
<noscript>
<a href="http://www.statcounter.com/" target="_blank"><img src="http://c7.statcounter.com/counter.php?sc_project=724140&java=0&security=0fc5f449"
alt="free invisible hit counter" border="0"></a>
</noscript>
<!-- End of StatCounter Code -->
<!-- Start Google Analytics -->
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-227751-3");
pageTracker._trackPageview();
</script>
<!-- End Google Analytics -->
<!-- PAGE AREA END --></div>
</form>
</body>
</HTML>
| | | | | |