Hi, create 2 tables.
1. States of Death
2 Cities of Death
In States of Death create 2 fields
In Cities of Death create 2 fields
Create a relationship betwen States of Death and Cities of Death tables using the field State=State. Since only the state of Rhode Island will be in the State field in the City of Death table, you can create a conditional value list in he SofD table based on the relationship State to State. Use a Drop down list in the SoD table and choose values from field city in CofD table based on the State relationship and this will on show a list of the cities when Rhode Island is entered. You can also manually enter cities of other states.