displaying dynamic text from another table
after I have input information using dynamic dropdowns from either insert or update pages the results or details page show the ID(fk) numbers.
Is there an easy way to display dynamic text associated with the ID(fk) text fields?
I managed to create an inner join in another section of my project, but when I attempt to do it on something a bit more complex the sql error says I'm attempting to mess with a template or translator and the changes will be ignored on the RS. And if I create another RS it simply throws the first text from the table in every repeated row. I just can't seem to get it to update from the dataAssist generated info. I have the DA suite and its an amazing set of tools, I would have thought there would be a simple solution to adding this additional dynamic text inner join.
TIA
Russ