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!
Autofill question (1 Viewer)
- Thread starter afisher
- Start date
- Local time
- Today, 04:53
- Joined
- Oct 29, 2018
- Messages
- 21,473
Hi. Welcome to AWF!
Sounds like you're talking about a lookup or a reference data. If so, you'll need a separate table for that and use a field in your current table as a foreign key to that table.
Look up "database normalization" to learn more.
Sounds like you're talking about a lookup or a reference data. If so, you'll need a separate table for that and use a field in your current table as a foreign key to that table.
Look up "database normalization" to learn more.
- Local time
- Today, 07:53
- Joined
- Feb 19, 2002
- Messages
- 43,275
This example shows a couple of ways of having a combo and displaying other fields from it. It might help you.
Autofill and other examples
This database shows examples of how autofill works. It also shows examples of filtering with a multi-select listbox. I added an updated version of the database with additional examples.
www.access-programmers.co.uk
