I have a project where I have a variable (MediumText) that is formatted as HTML in the ADD view in TABLE1 that I would like to do a Lookup from Table2 and put the results into a "Text Area" Edit and HTML View structure. However when I use the Lookup Table option, I no longer have the ability to use the Text Area format for the EDIT view.
When I use the Lookup, the lookup works correctly but the data view is no usable and when I use the Text Area, it works correctly but I lose the lookup which defeats the whole purpose.
How can I use the Lookup Table and also the Text Area structure together?
Dean