Passing Session Variables - Help?
Hi all,
I'm having trouble trying to pass a variable from one page/form to another and hope you can help.
I have two tables - prop_details and prop_images - I created a relationship using prop_id in both tables.
My first insert form posts data to prop_details and then redirects to my second page/form where I want to display two session variables (prop_id and prop_ref from prop_details) and then pass those to prop_images to create the relationship.
I have created a recordset in my 2nd page/form but cannot display the two session variable to post to prop_images
SELECT prop_id, prop_ref
FROM prop_details
WHERE prop_id = colname
what am I doing wrong?
With thanks
Phil