How to write an id of an item of another table and automatically equal it to the text

See more:

SQL

hi, the title is messed up i know :D
i have a table called city , there is two columns, city id and city name
now i have another table called flights with three columns, id, time, and city id
i have an item in city table, id=1, city name= slemani,
and now i open flights table and write id=1, time=bla bla, and city id=1
i want to automatically change the city id to the city name, slemani id is 1, and i write 1 in city id, i want that 1 change to slemani automatically, how to do it?

What I have tried:

i tried to get a text using it's id