Hi folks,

I'm trying to search for a link in multiple tables in my database and update that link on the web form at once if found. I have trouble with the logic of running through all the tables to find and display it on the form. Would you please guide me how to do it!

table 1:

field name data
*****************************
bookType history
location aaa
bookName American history
id 1
link http://www.yahoo.com

table 2:
/////////////////////////////////////////////////
field name data
******************************************
bookType history
location bbbbb
bookName Mexican history
id 2
link http://www.yahoo.com

/////////////////////////////////////////////////////////////////////
Thanks so much

td

Do a union query to return all rows from all tables containing that link, the primary key to the table and a calculated field with the table name. Then use that result set to update your tables with a loop.



Sal

I guess a union query would work, but I can't help but ask, WHY why WHY WHY Why whY WHY do you have two separate tables that store the same type of data?


Take care,

Nik
http://www.bigaction.org/