Just when I thought I understood how to implement SQL Pass through in MM, I had a request for an addition to a lookup form that required me to change from a view to SPT. However, it doesn't initialize any cursor so the lookup grid isn't getting initialized properly. The SPT appears to be working properly, but now I need to know what to do on the Grid to get it working properly. It comes up with everything blank and all of the records. If I toggle through and "guess" on a selection, that comes back as the correct selection.
Any advice is appreciated?
Rod Lewis