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