Let's say that I have two tables - Cars and CarType. Cars has a CarTypeID - a foreign key field.

I wrote a stored procedure that joins Cars and CarType, it also takes one parameter - CarTypeID.

How do I create a report in InfoAssist with a filter on CarTypeDescription but passed CarTypeID to the stored procedure (I would like to filter the data by the ID instead of the description field to improve query performance)?

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

I realized that the way to do it is by using the accept - FOCEXEC option in the master file to reference a lookup procedure