Hi There,
I have an event with multiple activities. The event has an id [ev_id] and the activities has an id like [wk_id]
table_event with ev_id as primary
table_activities with wk_id as primary and a linked field ev_id (that links to the event)
The event has taken place and now the users would like to copy that event (that’s not the problem) and start a new one. So far so good, except i wan’t to copy all of the activities at once with it and i can’t get a clean solution.
So what i wan’t to do is, after the event is copied. look for all the activities in the table_activities and copy them and change the ev_id of the activities to the ev_id of the new event and give the activity a new id (wk_id, not a problem is auto-increment and primary)
any suggestions?