More than one column for a link

In our company lets assume we process some raw materials.
For example 
CLAY, FELDSPAR, CAOLINE and QUARTZ
and after processing assume there are 4 quality ranges specified.
1st Quality 2nd Q 3rd and 4th.

For example 1st quality Feldspar is given a code number like 
11011 and 2nd=11012 3rd=11013 4th is 11014

Lets think the table products is designed as follows:
Code    Name          Quality    Color   Smell   Note
11011   Feldspar      1st        Gray    Sharp   Notes&Notes&Notes
11012   Feldspar      2nd        Green   Mild    AnotherNotes&Notes
.
.

continues....

In a 1:N-relation-designed form like an ORDERS form, the operator 
have to select the name and quality of the product because 
the two are the speciality that differs the product from others.
Or the operator has to memorize all the code numbers.
Memorizing code numbers are easy in this scenario but if the
number of the products grow, it becomes impossible to memorize.
The operator has to select from the two LINKS (DROPDOWN s) combination

Is it possible this kind of a scenario put into practice. 

-- 
_______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.