I know this may be a simple question but this is what Iam wanting to do:
Say I have a table Called tbl_Cities In that table I have a drop down menu which gives me ONLY the name of a Region from the table tbl_Regions. I then add all the information for that city including selecting the Region name I want from that drop down.
THEN I go to the region table which I have all the info for each region INCLUDING a cities field. What I want is to have ALL the city names that SELECTED a specific region name in the drop down menu and have a list of the city names show in that "Cities" field which would be uneditable except by of course editing the info from th city table directly.
Anyone know how this could be done?
