Create new filter on form

(0) Share

Report

Posted on by Johnny

6,478

Hello,

On the po planned order I want to create new Filter (VendorId). By selecting the Vendor in lookup, the grid should be filtered accordingly.

What would be a best approach?

So, I will create an extension of form. Create new String field. And then how can I have this field as lookup to vendors and filter the grid based on it?

Thanks.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (1)

Report

Just use the right data type (VendAccount, I think) for the string control and you'll get a lookup automatically.

Create a handler for OnModified event of the new control to execute logic when a vendor ID gets specified. Then add/modify/remove a range from the form query.

Was this reply helpful? Yes No