Forum

This content is now out of date.

Visit Our Community

Stored Procedure – Client Reference ID

Is there a way to filter stored procedure results by Client Reference ID? I am not seeing this as an option when I setup a view using a stored procedure.

Thanks,
Steve
Hi Steve,

In order to apply a source filter to a Stored Procedure view, you will need to apply it to an actual parameter, not to a column.

E.g.

Forum image


So in your case, the parameter will link to the Client Ref ID.

From that point, it then functions like a standard access filter.

Please let me know if you have any other questions on this, or run into any issues.

Regards,
David
Thanks David. I will try this out.

Regards,
Steve