Free SQL Lookup Search for Customers, Vendors and Items

(0) Share

Report

Posted on by David Musgrave MVP ...

13,856 Super User 2024 Season 1

If you have ever wanted to be able to search customers, vendor and items just by entering any data you know and pressing tab and getting a list of all records containing that data (case insensitive), then here is a treat for you.

I have created a free sample that adds this functionality to the main cards, inquiry and transaction windows for customers, vendors and items.

Just download and install it into your GP Power Tools - Developer Tools module install. Don't have GPPT yet, then install it and activate the free 30 day trial. It does need build 28, so if you are running on an old build, please update all your workstations.

Here is the sample: https://winthropdc.wordpress.com/2020/08/17/gppt-free-sql-search-across-multiple-fields-lookup-example/

Here is build 28 release notes: https://winthropdc.wordpress.com/2020/08/11/gppt-gp-power-tools-build-28-released/

Available for GP2013 or later.

Let me know if you have questions.

Enjoy

David

All responses (1)

Answers (0)

Isaac Olson on at

Like (0)

Report

RE: Free SQL Lookup Search for Customers, Vendors and Items

Thanks for using the discussions page to share this information.