Hey thanks for all your help, i am hoping someone from WA or the community can help here.
I can get my insert into another table on the fly work, however when i create an update on the fly, it creates a new rox in the database rather than update that existing row.
The update of the product works fine but the payments table update creates a new row rather than updating the existing row.
I tried setting it to the session variable at insert of payments table which works great until i log out go to another pc then it wont work when i update as the isnert was done on another computer so cant update based on the insert session variable.
anyone any ideas?
thanks