Pre-Qualifying Vendor Group

[LOUM]

Good Day Everyone,

I have 2 queries I have joined.

1. Vendor File
2. Payment Records

On my prompt page I want to filter the vendors to only include the vendors in the Vendor file as the payment file has more vendors in it than the vendor file. (Purchasing type in Vnedor and All vendors in payment)

How do I prefilter my vendors on the page? I need it to be flexible so that i can select one or multiple vendors.

Regards,
Lou

[blom0344]

I mat be missing the point, but why not define a seperate prompt query against which ever table (you need /want)  and feed the associated parameter value to the data query?

[LOUM]

Blom thank you got it.