>A table with references is not changed at all during a procedure and is related to another. If the referred table were in memory it would require fewer disk accesses and run faster. Is there a way to accomplish this?

FoxPro is good in caching data w/o any additional help. If you provide enough memory for VFP buffers with SYS(3050) and table is accessed frequently, it'll be in the memory.