I am very new to Access and can't seem to find anything to achieve what I am trying to do. I have tried multiple things and can't get my form to work the way I want.
Attached is my Access database. In it I have a table with a chemical list, and then a form.
I am trying to get the form to be a lookup of the data that is in the table. I would like to be able to search either by chemical name or chemical manufacturer.
When you search by the chemical name it will populate the manufacturer, the SDS link, health, fire, reactivity and PPE combo boxes/ textboxes.
If you look up the manufacturer, it will provide a list of chemical names that are associated with that manufacturer. Then you would choose the chemical name you want, and it would do the same as above.
I am not sure if this can be done, but I am just trying to find an easier way to find an SDS along with they ratings.
Thank you in advance
Attached is my Access database. In it I have a table with a chemical list, and then a form.
I am trying to get the form to be a lookup of the data that is in the table. I would like to be able to search either by chemical name or chemical manufacturer.
When you search by the chemical name it will populate the manufacturer, the SDS link, health, fire, reactivity and PPE combo boxes/ textboxes.
If you look up the manufacturer, it will provide a list of chemical names that are associated with that manufacturer. Then you would choose the chemical name you want, and it would do the same as above.
I am not sure if this can be done, but I am just trying to find an easier way to find an SDS along with they ratings.
Thank you in advance