IMO, the best thing is to do additional queries into the other files and return additional recordsets.
>Hi all,
>
>Some advice,
>Example: Working in a Customers Form, retrive the information from SQL Server with ADO RecordSet, but the Customers file have references to the State File, Province File and so on, what is the best way to retrive the recordset from the Customers file and then get the State name from State File, Province Name From Province File.
>Thank’s
>
>João Batista
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer