Hmm, well, that sounds like a great technique (into my toolbox with that), but the problem isn't storing the temporary data - a VFP cursor works just fine, it's getting it joined with the large customer table without bringing down the entire thing to join with the cursor.

Thanks.


>No, it's available to any connection and exists as long as there's some connection referencing it. I use it by creating a table of matching primary keys from VFP and then calling Crystal Reports to do the appropriate selects based on those primary keys. It means that the users get great control over what data they want presented and how it's presented (from Crystal reports) and I get great control over which records actually match their criteria.