Summing records from a table to another

[JohnPol]

Good Day,

 

I am trying to add several records from one table in another record, in another table.

 

This DB is based on a process that has two steps. From Step 1 to step 2, some records need to be merged.

 

Table1 is 50 records, one field in particular is ItemID, one is ItemAmount.

On Table 2, I have 0 records and I have a some fields similar to Table1, so I am populating them with lookup. The relationship is based on ItemID.

So far so good.

 

But some records on Table1 now need to be merged to one record in Table2, in particular, the ItemAmounts need to be summed to generate Table2::ItemAmount...

 

I want the user populating Table 2 to specify the ItemID's from Table1 to be merged (summed), they can need to merge 1, 2, 3 or up to 10 Items from Table1.

 

I have tried TypeSumField, scripts, multiples relationships, functions, but...

I am completely lost to even what feature of FM should be used here... portals ? beuh...

 

thanks for your precious help,

 

JP

 

[eos]

Not exactly sure what you want, but this might give you a start. File has only basic error-checking; e.g. depending on your business rules you may want to make sure that an item isn't summarized multiple times, i.e. flag it and prevent the script from running again, plus all the usual cautionary measures.

SumThisUp_eos.fmp12.zip