AnsweredAssumed Answered

Generating a table based on another....

Question asked by jwilson on Oct 19, 2015
Latest reply on Oct 22, 2015 by jwilson

I have a table with 4 fields:

 

          Name;   # Portions fruit;   # Portions meat;   # Portions Fish

 

And based on this data I want to be able to generate a Table that has three fields:

 

          Name;  Type of Food;  # Portions

 

One record in 1st table could thus result in up to 3 records in the second table.

 

Ideally I want the second table to be populated at the same time as the 1st, but it would also be acceptable to  generate the second table as a one off event (ie triggered by a script).

 

This looks like a ridiculously easy task but I just cannot see how to make it work and any help would be very much appreciated

Outcomes