GL Code Contains Lookups

[Nancy Palmquist]

Stanley,

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.

Nancy

On 10/18/2019 3:33 AM, Stan-Lyn,Stanley Barnett via Filepro-list wrote:
> 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: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191018/b15723d8/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191021/d1ea9259/attachment.html>