combining tables

  • Thread starter Irvine S Russell
  • Start date
I

Irvine S Russell

I have two tables, one containing the current teams in our office and one
containing the old teams.

Is there a way that I can combine these two into one to use as the row
source of a combo box in order o filter the records of a form.

The list of current teams is available to the user to update, but the old
teams table is hidden
 
K

KARL DEWEY

Yes you can append old to the new. But first I would add a field in the
'new' table like "Old" so as to know which is which.
In your append query add a column like --
X: "X"
Append column X to the Old field when you append the old names.
 
I

Irvine S Russell

I wanted o keep the two tables separate, bu be able o use them ogether in the
Combo
 
G

G. Vaught

Construct a UNION Query. There are some rules to follow.
1. The Union query is hand typed using the View SQL within a query.
2. The fields in both tables must match in datatype and size.

So lets assume that the old table and new table match in datatypes and
sizing.

Select teamname from new table order by teamname

UNION

Select teamname from old table order by teamname;
 
Top