Hello Access Experts,
First, I am very new to Access and need some assistance.
In summary, I have been tasked with creating a databse that contains multiple test records. Within a single test record, there is a field named 'bits' in which there are 10 different bits (0 - 9) each with a different value and description.
I would like to set up the database such that a user can view a single test record and select a particular bit field from a drop down box and when the bit is selected, the descriptive information for that particular bit is automatically displayed to the user.
For example:
- User selects 'test record A'.
- Within 'test record A' there is a 'bits' dropdown box.
- From the 'bits' dropdown box, the user selects bit '0'.
- When bit '0' is selected, another field named 'bit description' automatically fills in the bit description for bit '0'.
I hope I was able to explain the goal. Please HELP
Thank You,
Neuhur