I need to be able to select values from a list based off two columns/fields.
To keep it simple, I have a table that has the following fields Tool, Size, Description. Tool and Size are not unique, but the row itself is unique: For example:
Tool, Size, Description
Wrench, 14 Description A
Wrench, 14, Description B
Wrench, 15, Description Z
Wrench, 16, Description 1
Wrench, 16, Description 2
Wrench, 16, Description 3
When the user is entering detail on a data page, they must select a Tool, and a Size, but then they need to be able to select one of the descriptions from the descriptions with that Tool/Size combo. For example if the user selected Wrench and size 16, then the Description 1, Description 2, and Description 3 would be available for selection.
This would be easy with a Select statement as the source for a drop down, or if I could simply use a concatenated formula field as the parent field for the cascading drop down. But that's not an option. This seems like it is pretty standard, so I'm sure I'm just missing something simple.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
AccessNerd
I need to be able to select values from a list based off two columns/fields.
To keep it simple, I have a table that has the following fields Tool, Size, Description. Tool and Size are not unique, but the row itself is unique: For example:
When the user is entering detail on a data page, they must select a Tool, and a Size, but then they need to be able to select one of the descriptions from the descriptions with that Tool/Size combo. For example if the user selected Wrench and size 16, then the Description 1, Description 2, and Description 3 would be available for selection.
This would be easy with a Select statement as the source for a drop down, or if I could simply use a concatenated formula field as the parent field for the cascading drop down. But that's not an option. This seems like it is pretty standard, so I'm sure I'm just missing something simple.
Can anyone help???????
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.