Form fields : How to auto populate different fields

You’ll probably need to switch to a Custom Form. Then you can have your choice write to a User Specific column. You can then use that value to create a relation to your Products table, then use Lookup columns to obtain the values that you need.