If the price changes depending on color and material, you need a table of products where each color/material option is a different record so that you can assign a different price to each.
I tried that but I could only select one of the same name. ex. (sink name = 801L and I have multiple 801L records with different color/material options, I can only select one of the 801L options in the drop down.)
How would I avoid having multiple duplicate names that have different prices?
You will need an identifier that is unique to each record. This can be an auto-entered serial number and you can use a "name" field associated with it that is also unique, such as a text field that combines name, material and color.
Or you can set up a relationship that matches by the ID, material and color fields in a relationship using 3 pairs of fields.
Other options are also possible.