Let me try to explain what I am doing.
I have a list page of missed detentions, based upon a custom view which filters all the records and shows all those that have not been attended (`done`<>"1"<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9506&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' /> and having a date less than or equal to curdate().
This shows all the missed detentions.
there is a master slave relationship with another list page based upon a different custom view. The link is between the pupil ID field, pup_id, in each of the views.
The slave table has a primary key of id_det, but the masterkey between the two is pup_id.
the slave view is called Re-assign.
So the link next to the missed detention on the master view appears as Re-assign. Neat eh?
When I click on Re-assign, I get the list page of all of that pupil's detentions, so I can see what he/she has in the future, I then use an inline add to allow giving another detention and still see the dates that are used.
There are 4 fields from the original detention record that I would like to pre populate the new record with, some need to be concatenated into a text string to enter into the comments text box, so it says "This is a follow up detention from the one missed on ".$date_for_detention." given by ".$teacher." blah blah blah.
This needs to be inserted into the field for the comment but it should be editable before the record is saved.
When I save the record, all needs to run as normal, but I need to clear any session variables used, as more than one detention will be re_assigned in a session.
I haver tried bits from my recent posts on here, and I am getting nowhere.
Please help
Cheers