GL Code Contains Lookups

[Stan-Lyn, Stanley Barnett]

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>