Hi Access Nation!
I'm in the planning stages of designing a database and wanted feedback on which direction to go.
How Users Will Enter Data
Multiple users, each with their own ID and Port location, will enter data called Effort counts. At each Port, they will make Effort counts at several Areas. Ports have their own unique Areas. There are multiple Areas for a Port. In a form, I would like them to enter Port and have only the Area choices for that port, instead of the (too) many choice for all ports.
Which Solution?
Since there are multiple Areas for a Port, I'm thinking linked tables like below won't work since tbl_Effort would actually have Area1, Time1, Count1; Area2, Time2, Count2; etc.
Attachment 33218
Does this mean using look-up tables? In the form, would I use a cascading combobox? How does this work with lookups (one for each Port)? I've looked at this thread and the warnings about lookups here. I think the difference between that thread and my situation is that there are multiple entries in tbl_Effort, all which call on Port and Area. What am I missing? What is the best practice?
Again, I haven't actually designed anything yet. This is an example of multiple types of data that will go into the final database. Thanks for your help!