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
To convert your existing data, you could simply do 3 imports, where after the import you use Replace Fields Contents to set the type according to the field from where you imported.
For future use, just create the required child records in your “Portions” table and set them to the desired type.
thanks erolst.... this was enough to trigger my addled brain into action, and I have made a script based on your suggestion. Works fine.