AnsweredAssumed Answered

Multiple portal rows from one record

Question asked by user2147414 on Apr 4, 2018
Latest reply on Apr 4, 2018 by philmodjunk

Hi Filemaker Gurus

 

Here is one for you to tackle:

 

I have one table with data;

Table 1

Index; Field 1; Field 2; Field 3; Field 4; Calculation field 1

1; Fruit; Apples; Bananas; Lemons; 3

2; Fruit; Bananas; Apples; "" ; 2

3; Fruit; Lemons; Grapes; Apples; 6

 

Another table contains

Table 2

Index; Field 1; Calculation field 1

1; Apples; 4

2; Bananas; 2

3; Lemons; 3

4; Grapes; 2

 

Can I create an "autoupdating virtual" portal containing separate lines for each individual fruit, like this:

 

Repport

Field 1 (index number from table 1) ; Field 2; Field 3; Field 4

1; Fruit; Apples; 1

1; Fruit; Bananas; 1

1; Fruit; Lemons; 1

2; Fruit; Bananas; 1

2; Fruit; Apples; 1

3; Fruit; Lemons; 2

3; Fruit; Grapes; 2

3; Fruit; Apples; 2

 

 

I know it can be accomplished quite simple with scripting, copying every value to a new table line, but it means using cpu time for updating. Is there any way to this "on the fly"?

 

 

Best regards, Anders Malmros

Outcomes