I need some guidance here.

I have 3 tables with the exact same column names. Each table has a list of all 50 states in column 1 (one has four of each state) and column 2 is product name. I am trying to use a page to view/edit this information separately (which I got) and all at once (which I need).

I this even possible?

Maybe this will help...


tbl1

Column 1, Column 2, Column 3
Alabama , MAP , info
Alaska , MAP , info
Arizona , MAP , info
Arkansas , MAP , info
ect....


tbl2

Column 1, Column 2 , Column 3
Alabama , Credit , info
Alaska , Credit , info
Arizona , Credit , info
Arkansas , Credit , info
ect....

So why three tables? Why not one?

You should have all this data in one table. When you want to look at this by product, you use a query.

I did have it all in one originally.

For example...

Column 1, Column 2, Column 3, Column 4
Alabama, Map , ect...
Alaska , Map , ect...
Arizona, Map , ect...
Alabama, Credit , ect...
Alaska, Credit , ect...
Arizona , Credit , ect...
Alabama, DZ , ect...
Alaska , DZ , ect...
Arizona , DZ , ect...

Would I have to have a seprate query for each Column 2 (Map, Credit or DZ)
What if I wanted to include 2 of them?

Thanks for the help, I got it.