Return Search criteria to form attributes.

KnightWare

I have two attributes on a Form, Vendor_Number and Vendor_Name. I have a Vendor BO linked to an external SQL DB. Whats the best way to incorporate the External data? I thought a "Search Icon" next to the Vendor_Number text box, but can't seem to figure out how to make that work. The user May know the number, so type it in and "on change" lookup the Name and return it to the Name attribute? Or the user may need to open a search form, using what they know of Number OR Name, select the record and then want the Number and Name field to populate with their selection.

I've loaded some of the sample apps, but not finding any examples there.

aware_support

Not sure I fully understand this, but you can add a custom button to your form that runs a process.

Jaymer

CASE 1
The user May know the number, so type it in and "on change" lookup the Name and return it to the Name attribute?
Maybe you're not familiar with the Dynamic rule checkbox in the Properties window of a Rule.
Screen Shot 2018-10-30 at 10.26.00 PM.png

CASE 2
Or the user may need to open a search form, using what they know of Number OR Name, select the record and then want the Number and Name field to populate with their selection.
Create a button (as Vlad suggested) and run a Process which does a PICK FROM.
That window that pops up can be a grid with filters, so you can see the Vendor table and search it. Click a [ ] when you're on the one you want and it will get returned to the process.

jaymer...

KnightWare

Thanks. Evidently you cannot use Native functions on SQL data.

Internal error. Element REPLACE_PATTERN in query condition REPLACE_PATTERN(Vendors.VENDOR,' ','')=VendorLog.Vendor of query FIND Vendors WHERE REPLACE_PATTERN(Vendors.VENDOR,' ','')=VendorLog.Vendor cannot be converted to the currently installed version of SQL