I am trying to use a storedprocedure as a lookup function. I can not get it to work. The sp returns a one row result set.
The sp generates record id's for the destination table, if there is a better way to utilize the sp I am open to suggestions.

Thanks
Darryl