Topic: How do I compare to tables?
I did a search and I also tried to search the Agile Rails book but maybe I wasn't using the right words, but how do I compare tables?
I've got a table with a list of cities and their respective states already filled out called "cities". Then when someone fills out, what would go to the "addresses" table, I want it to first check with the "cities" table to see if it's a valid city/state. If so it will let them save. If not it will do a flash notice to tell them to check their spelling or whatever. Or could I just have the textbox autocomplete from the "cities" table, but save to the "addresses" table?
Thanks as always.