Hello
I'm new to Access
I am currently trying to set up a database
In one of the feilds I have created a drop down with about 15 different items to choose from - the problem I have been given is that my boss wants the database to automatically populate some of the other feilds with
with certain comments applicable to the selection made in the drop down
Which is the best way to set the database up so that when a certain selection is made in one feild it automatically fills in other feilds with relevant info?
I'm new to Access
I am currently trying to set up a database
In one of the feilds I have created a drop down with about 15 different items to choose from - the problem I have been given is that my boss wants the database to automatically populate some of the other feilds with
with certain comments applicable to the selection made in the drop down
Which is the best way to set the database up so that when a certain selection is made in one feild it automatically fills in other feilds with relevant info?