Sorry for the confusing title. I’m having trouble describing what I’m trying to achieve. I have a form with a drop-down field. The values are things like “Uber”, “Lyft” and “Airbnb”. If the user selects “Uber”, I want the entry in the database to not only capture the entry of “Uber”, which works fine, but I also want it to automatically add the value of “transportation” to the database where I have a field labeled “category”. Similarly, if the user selects “Airbnb”, I want the database to know that is category “Accommodation”, and populate the field accordingly in the database.
How can set these associations, and have the database entries automatically populated with the category? I don’t want a “Category” field on the front end