Given two SQL Tables [Client and Group], each table has 1 column (to simply things), a form [Frm], and a ComboBox [cb].

For the SQL Tables:
- Client has a column called CUSTOMER
- Group has a column called GROUPNAME

What I need is to display all values in column CUSTOMER (from Table Client) and GROUPNAME (from Table Group) in the Combobox as one column of choices.

Currently I am easily able to do an SQL search on Client (get back a recordset) and use that as a datasource for my Combobox (works great) to display all Customers.

So I need one of the following:
- An SQL call that can take both tables and return a column with Customer and Groupname all in one
- A way to merge two recordsets (I would do 2 SQL calls, one to generate the list of CUSTOMER and the other for GROUPNAMES then merge the recordset and display it)
- Or a way to display 2 columns (either 2 columns in 1 recordset or 2 separate recordsets) as 1 in the Combobox.

I hope that was a clear explanation.
Any ideas would be appreciated.
I might be going about this the wrong way.