<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<tt>Stanley,<br>
<br>
Use browse and try the FUZZY search on a field which has the tag
name. When they select what they want, get the GL# you want from
the selected record.<br>
<br>
Nancy<br>
</tt><br>
<div class="moz-cite-prefix">On 10/18/2019 3:33 AM, Stan-Lyn,Stanley
Barnett via Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:5f17826e0a824cecaf503611f5428997@stanlyn.com">
<pre class="moz-quote-pre" wrap="">Hi,
I'm trying to come up with an easy way to do a GL code lookup by a tag name. The idea here is the GL table has a long field named "tags" where tag names will be added in any order.
Then when the user triggers a lookup via a hot key within the accounts payable form, it presents the user with an input popup that receives a value from the user to search for. That value will then be used to do a "contains" search against the "tags" field.
The system then presents the user with a selectable combo box with all the records that matches/contains the value searched for. The user selects one and presses enter and the GL # will be inserted within the AP.
Any ideas on how to pull this off? The forms are full with no scrolling fields. Upgrading is probably not an option, however if there enough compelling stuff, then they may be interested.
Thanks,
Stanley
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20191018/b15723d8/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20191018/b15723d8/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>