I've many different tables with a join on a field called city, each user can manage only one city, and the city parameter is filled into user registration form. All the other tables the user fill need to be completed with the city parameter, and that parameter is always the same, i just want to add it automatically in the form of the others table.
ex. TABLE USERNAME : Field Username , Password, City
table 1 : field {HISTORICALPLACENAME, DESCRIPTION, IMAGE, CITY(always the same, it depend by user who menage that city)}
table 2: field{HOTELNAME, DESCRIPTION, IMAGE, CITY}
.
.
.
.
all the table are related by CITY field, so i thought to put an hidden field inside each table with CITY parameter of user who manage it.
Can you help me?