Thank you all.

Dubbya, I have been trying that and just can't figure out what I'm doing wrong because it wont work for me. I have pulled out half my hair...lol.

The reason I have so many tables with all the same fields is that eventually (future expansion) after some growth, thesee tables will have fields added that are NOT the same.

On another site I did it with just the one table and called up needed info by a category field - but - then when the many different fields were added for the many different categories it ended up becoming a pain in the you know for many reasons. I'd rather have the different tables if I can get it to work.