Looking up a field value to include in an email

I have a page used to add a record to a table, which also triggers an email.

The table structure includes:

nominations

NominationID (PK)
CategoryFullID (FK)
etc

categoriesFull

CategoryID (PK)
Category
etc

The form is adding a record to the nominations table, including the field CategoryFullID.

I would like the email to include the Category field for the CategoryFullID in the form, but can't pull it directly from a form value, as the form is only adding the CategoryFullID, and not referencing the Category itself.

I have had a stab at it, by trying to

- store the CategoryFullID value in a session (CategoryValue) when the form is submitted.
- use a query (rsCategories) to return the record from the categoriesFull table where the CategoryID = the value stored in the session.
- echo the Category value fro that record in the email.

I hope that makes sense - I'm sure it must be possible, even if my attempt is all wrong!

Copy of the file and other details below.

in your private message, you don't include a link, I'm pretty good at figuring stuff out, but i have no idea which index.php page in your site is the one that you are having the problem with .

one thing i do notice with the file that you sent me, is the UE code block uses a file named webassist/email/waue_index101_1.php fo the settings, but I don't see that file on your server:

include("../webassist/email/waue_index101_1.php");

please give a link to the page so i properly troubleshoot.

Sorry Jason - was the wrong site details - have amended them above. The webassist/email file should be wake_index_nomination_category.php

the select list for the category is named Parent:
<select name="Parent" id="Parent" onchange="WA_FilterAndPopulateSubList(Child_WAJA,MM_findObj('Parent'),MM_findObj('Child'),0,0,false,': ')">

your code to set the session:
$_SESSION["CategoryValue"] = "".((isset($_POST["CategoriesFullID"]))?$_POST["CategoriesFullID"]:"") ."";

refers to a form element named CategoriesFullID which does not exist on the page, it should be edited to use the Parent form element instead.

Thanks Jason - that's working now.

you're welcome.