Jump to content

Portal - Recipe, Ingredients and Nutritional Elements


This topic is 2809 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Good morning guys, :)
I am relatively new in filemaker however it is amazing how quickly you can develop an application that saves us a lot of time.

However, it is a week that I got stuck in development.

I am creating a database for the management of some recipes, for which I need to select all of the ingredients (in a portal) and make sure to display on another portal the list of the nutritional elements.

For this I created three tables "Recipes", "ingredients", "nutritional elements", plus 2 join tables "Recipes & Ingredients" and "Ingredients & Nutritional elements".

For example, the recipe "Spaghetti Bolognese" is composed of "pasta 50%" and "tomato 50%".

The problem is this: in the portal I must display the nutritional element name and its concentration (10% crude protein), whose concentration is the sum of the protein made from pasta, and the protein made from tomatoes (so it is a field calculated).

I ask you for advice on how to proceed. :(

Link to comment
Share on other sites

This topic is 2809 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.