>I am getting all records from File1, fields from File2, and the correct fields from File3, but it seems I am always getting the field data from the first record of File4 for all records in the result.
>
>PLEASE HELP ME!

I know this is not a direct answer to your question, however, I like to use the query wizard to build my selects. You can play with it until it is just the way you want it. Once there you just right-click and View SQL, copy and paste into you program.

DJ :o)