I would like to create a link between two databases based on the following logic, but I am not sure if this is possible to do in FlutterFlow. Can anyone help?
One database contains food items, e.g. onions, bananas, potatoes etc. with nutritional information for each food item.
The other database contains recipes which are composed of food items from the first database and corresponding amounts of food, e.g. potatoes 75 g, carrots 124 g etc.
Database screenshot:
I have a new_recipe page (screenshot below), which allows me to add the recipe name and recipe description. After that I have a dropdown list of ingredients (based on the foods database - working fine, see second screenshot below), and a field for ingredient amount.
What I am trying to accomplish is to be able to add ingredients with corresponding weights, and then once I am happy with all the ingredients and weights, to save the recipe to the database.
After each ingredient (and corresponding weight) is added I'd like to display a table with the ingredients + weights added so far (on the same page, e.g. between the "add ingredient" button and the "save recipe" button.
Can someone provide any guidance if this is possible, and if yes, how it can be done?