Hi everyone! I am new to access and currently stuck on an issue while setting up a database for a research project I'm starting. I'm trying to figure out how to autofill a locational (shorttext) ID based on latitude entered in another field within the same table. The zone IDs would refer to specific, pre-determined ranges of latitudes, so I need to be able to associate a range of numbers to a text ID. Ideally, I'd like to be able to enter a latitude in my associated form and have the correct zone ID autofill in a different field. Thank you in advance for any help/ suggestions!