I am working on a form that has cascading drop down lists, but the issue is that once the form is submitted, the database shows the number ID instead of the text. I know this is because value is set as ID and the Display Name is set as Title, but that is the only way the cascading drop down lists will work since it utilizes lookup values. I read that I could potentially fix the problem by storing the Display Name in a field and promoting that field when publishing the form, but I don't understand how to do this. If someone could give a step-by-step explanation on how to do so, it would be very helpful.
Also, will promoting that stored field hide the column that shows the ID number?