How to direct data to the tables that names are given in Combobox

J

Jaakko Kesavuori

I try to feed data to similar tables using Form. Purpose: stock accounting,
stocks in many places. I have names of stocks in Combo box located at the
same Form where the data are. I have tables of the same names. How to direct
data for instance to table "Jyvaskyla" that name "Juvaskyla" is chosen from
Combo box in the Form?

Thanks
 
D

Douglas J. Steele

You have multiple tables holding the same information (but for different
products, or for different locations)? That's probably not a good idea. You
should have one inventory table, with additional columns that serve the
purpose of why you had multiple tables.
 
Top