Hi
I'm testing the gathering data via email feature. So, I've created a very simple table (tbl_Person) with just 3 fields...
Person_ID
Person_Name
Hair_Colour_ID
Ive created another table (tbl_Hair_Colour) with just 2 fields...
Hair_Colour_ID
Hair_Colour
I've joined them in relationships and created a single form from the Person table. Simple. Works fine.
Now, when I select the Person table and click...
External Data > Create Email
I follow all the steps and manage to send an email to myself. The Hair_Colour field on the form is expecting a number but I want users to select from a drop down box in the email they send.
How would I make this a drop down box in the email ?
Thank you in advance
I'm testing the gathering data via email feature. So, I've created a very simple table (tbl_Person) with just 3 fields...
Person_ID
Person_Name
Hair_Colour_ID
Ive created another table (tbl_Hair_Colour) with just 2 fields...
Hair_Colour_ID
Hair_Colour
I've joined them in relationships and created a single form from the Person table. Simple. Works fine.
Now, when I select the Person table and click...
External Data > Create Email
I follow all the steps and manage to send an email to myself. The Hair_Colour field on the form is expecting a number but I want users to select from a drop down box in the email they send.
How would I make this a drop down box in the email ?
Thank you in advance