Dear Mr. Access expert/master/yoda,
Please see pictures attached first! I am looking to create a database. I have attempted to normalise the database. I will have 3 references all together. 1 for the substance, one for the supplier and one for the health risk. I am trying to make the database so it is really easy to input information. I am using reference autonumbers as the relationships for everything, although supplier company name is a unique identifier, also so is the substance name and health risk. Would that make my reference auto numbers redundant? Or is it best just to keep them in.
I would like to input a whole substances information (supplier info, supstance name and health risk). They would type a new name, then use a drop down menu to pick a supplier company name (autofills phone number and address), then use a drop down menu to pick the health risk (autofill of new picture). I would also like an option that if the supplier information is not on the drop down list then you can click a button and add a new supplier. Also a button so you amend the supplier information if it is out dated.
I know this is very basic thing so if you know of a online course that deals with it feel free to comment it.
Many thanks for reading! :D
Cheers,
Hottest Fudge
Please see pictures attached first! I am looking to create a database. I have attempted to normalise the database. I will have 3 references all together. 1 for the substance, one for the supplier and one for the health risk. I am trying to make the database so it is really easy to input information. I am using reference autonumbers as the relationships for everything, although supplier company name is a unique identifier, also so is the substance name and health risk. Would that make my reference auto numbers redundant? Or is it best just to keep them in.
I would like to input a whole substances information (supplier info, supstance name and health risk). They would type a new name, then use a drop down menu to pick a supplier company name (autofills phone number and address), then use a drop down menu to pick the health risk (autofill of new picture). I would also like an option that if the supplier information is not on the drop down list then you can click a button and add a new supplier. Also a button so you amend the supplier information if it is out dated.
I know this is very basic thing so if you know of a online course that deals with it feel free to comment it.
Many thanks for reading! :D
Cheers,
Hottest Fudge
Beginner trying to create a database
