Expert Help :: Refine App

First guess:
Make a relation in “CompanyConsumables” to “Consumables” based on the name columns in both tables. Then lookup column values which should be autocompleted. I think glide can immediately use the value in the choice component even before submission.
You might need some visibility conditions in the form and some if-then-else columns in your “companyConsumables” table.
Edit: if you can’t immediately use the value of the choice component for the relation: configure a custom form with the help of custom actions setting values in user-specific columns shown on new screens.