Merging same Item from portal 1 with total amount in portal 2

[Hermann]

After many hours working on that problem, i'm here in coummunity.

As an attachement, you find my data base. First of all, in text below in brackets I write the german name; my data base is in german.

In attachement is also a picture, this shows my problem zone.

In portal 1, I put in the preposition (Zubereitung) steps with all the ingredients (Zutaten). You can see, that Pos. 1 and 2 have the same article (Zutat), it's "Olivenöl". One time with mass 5 (Menge 5), one time with mass 2 (Menge 2).

In portal 2, under portal 1, there should be a merged ingredient line with the same articles. In this example there should be in only one line the article "Olivenöl" with the amount 7 (5 + 2).

Do you have any suggestion for the solution? Thanks a lot.

By the way, i discovered many entries in this forum, but the similar problems doesn't match with my data base schema.

cooking.fp7.zip

Edited September 14, 2010 by Guest
Picture added

[bruceR]

You have to select fields that are valid for the relationship.

[Hermann]

I think, i have done it so? Did you see something that is wrong.

[bruceR]

I think, i have done it so? Did you see something that is wrong.

Not only do I see something wrong; YOU see something wrong.

You posted the image that clearly shows invalid fields, marked as "table missing". So I do not understand your statement.

We have the added burden of the language difference.

[Lee Smith]

It looks to me like you changed your relationship for the portal, but didn't refocus your fields for the NEW relationship? Hence, the table is missing.

To correct it, go into layout mode, and click on the fields that show "Missing Table", and you can select the fields again by using the NEW Relationship.

HTH

Lee

Edited September 14, 2010 by Guest
spelling error