Populate a field based on drop down select in other field

Hi, I have a field (Drop down select ) named Product i want a text input field Production_amount to be populated based on what i choose from the product field .Pls not field Product is a from look up . On the table i have column : product |Production_amount | . under product i have Table water ,Sachet water . under Production_amount i have 100 for table water , 50 for sachet water . So if i choose Table water in my drop down select field i want Production_amount field to be 100. Thanks

You may use the Auto fill feature. Please read help file topic → Lookup Table → Auto fill on how to setup.