Arggh, think I may have spoken to soon and its live now! For some reason the email gets sent to the last record entered in db not the current record that's stored in session value?
For example:
case 100 - John Smith
case 101 - Kate Middleton
Case 102 - $_SESSION['tblcases_CaseID2'] this is taken from the insert behaviour
When inputting case 102 it should email the user being entered and filter the case id but it emails case 101 etc?
I have the email as the last part of the process, not sure how the previous case session is being stored? If I drag the session onto the page in testing it does indeed show the caseid I am creating and not the previous, so how is it getting the previous cases email address??
EDIT *** The above is incorrect, the previous case is held in session. If I add a case, then submit I can go to other parts of the site, return to insert cases page and its held the previous records value, is it possible to kill the session value after email? I have page if anyone can help..
Any ideas more than welcome..
Thanks