>Thanks for your reply. I'm fairly new to VFP...if I'm understanding your code correctly, the SELECT
>statement is dealing with two tables, whereas I would like to capture information from one .dbc file.
Nope. It's dealing with two instances of the same DBC. Did you try running the code to see if it would give you the right results?