Row Source

[inklady]

Quick question..

I have 3 tables that hold data..

I was trying to set up the autoexpand for my combo box.. Now.. If I understand this correctly, the autoexpand is based on the row source? I tried to design a query and put the sql code in the row source.. however to do this the tables need to have relationships. The tables aren't related, they hold separate information. So my question is.. how do I write row source, so I can utilize autoexpand on my combo box from 3 separate tables?.. I don't think making all the tables related to each other would work, since they don't hold any info that is the same..

Thanks!

 

[jdraw]

Please provide more info, or some sample data.