I’m trying to find an easy way for other teams (non-technical) to work with Many-to-many relationships with AirTable.
A simple example would be:
Authors, Recipes, Ingredients
A recipe could have multiple authors and multiple ingredients
An Ingredient can be used in multiple recipes
An author could have authorized multiple recipes
I want to create a way (a form would be nice) where a user could insert the necessary that would populate various tables. Some of the data entry fields might have auto-complete on them if they’re looking up an ID field.
If I wanted to enter in a recipe when looking up an author I’d like to see a list of what Authors are there, or create a new one. If I’m entering in ingredients I’d like to have a lookup as well because I won’t want to have mistakes in the ingredients table. (I don’t want to see Apple, apple, aple, appple, etc.)
How could I go about doing this?