I need to pick the top 3 records from 3 different tables. One of the problems I am facing are the tables are not related. To top it all off, they have to be random records for each table.<BR><BR>The tables are, Equipment, Services and Parts. The only way I could come with was to make 3 different recordsets, one from each table. <BR><BR>The really sad part about all of this is that I am not even that good at DB design. However, I think I know enough that when I see a DB with NINE tables in it and there are no relationships defined....there is a problem. I could be wrong. <BR><BR>Thanks in advance,<BR>ASP_DRUG_DEALER