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