Still having problems here
I tried making one giant recordset and I couldn't get it to work properly.
It brought up inaccurate information.
I think one of my many problems is in the recordset ...
I need to change the criteria in the WHERE clause for each table.
WHERE centerId = colname AND centers.VisitorID = tourneyad.VisitorID
(for one table)
WHERE centerId = colname AND centers.VisitorID = leagues.VisitorID
WHERE centerId = colname AND centers.VisitorID = coupon.VisitorID
I tried using AND operator for one giant WHERE clause...and I need a situation where if a visitor doesn't have something in one of the other tables...it will still bring up their other entered information.
Thank you again, for your help.