Question
Developer Toolbox SendMail issue
Hi all
I need to show the name of a chosen option that is from a dynamically generated dropdown in an input form.
These input details are emailed.
All this works but I get the integer value of the foreign key not the name
I understand the I need to set a new recordset filtered by the posted value from the form but for the life of me I cannot get the name from the foreign keyed table to show in the received email???
Can someone explain how to do this please as its driving me potty!
I need to show the name of a chosen option that is from a dynamically generated dropdown in an input form.
These input details are emailed.
All this works but I get the integer value of the foreign key not the name
I understand the I need to set a new recordset filtered by the posted value from the form but for the life of me I cannot get the name from the foreign keyed table to show in the received email???
Can someone explain how to do this please as its driving me potty!