Append Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have split a table's values listing work materials into several smaller
tables because the number of choices are too numerous to fit into one value
list. I'd like to make a new table that will include the values from ALL the
smaller tables and be choosable from a combo box on the form. Is this
possible using an Append Query?. and if so, how do I go about this?
 
Ridnaway said:
I have split a table's values listing work materials into several
smaller tables because the number of choices are too numerous to fit
into one value list. I'd like to make a new table that will include
the values from ALL the smaller tables and be choosable from a combo
box on the form. Is this possible using an Append Query?. and if so,
how do I go about this?
Click to expand...

Your table structure sounds incorrect. These values should be ROWS in your
table not COLUMNS (in which case "too many" is not an issue).
 
Back
Top