Create kp in a new table from imported join table kf
I have imported a database. In essence there were two files. One (foods.txt) was one side of a many to many relationship (foods - nutrients), the other file (nut_content.txt) was the individual records of what would be the join table. From these two files I want to create the 'nutrients' table (the other table of this many to many relatipnship). I have assigned _kf_food_id and _kf_nutrient_id in join table. I have created new NUTRIENT table and field _kp_nutrient_id. How can I extract the _kp_nutrient_id form the _kf_nutrient_id of the join table? Got me beat, is this really simple and I can not see it? Been trying for hours.