Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
My table name is held as data in another table...
Problem is that I don't know what tables there will be in existence (in addition to "item") as these are created dynamically too! Furthermore, the columns between the tables will not be consistent so merging into one isn't an option either. As the database may ultimately extend to many tables... -
My table name is held as data in another table...
Can anyone help? I have a table in my database called "item". This table holds data that is common to all items in my database and has a primary key of 'id'. One of the columns in the "item" table is 'itemtype' which tells me which table I need to go to for the remaining data for that item...
