get value from select field
Example : i have 10 material name and price , when i select the material name HOW to return the price to me for calculation
Each row in your example data should be a separate record. And you need a related table of materials and prices. Then a relationship combined with a looked up value field option can be used to look up the price for a given material.
See this thread for a detailed description of how to look up data from a related table: Auto Fill
Retrieving data ...