displaying dynamic text from another table

[Russell Collins]

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

[Ray Borduin]

You should be able to add the inner join. There is probably a bug in CS4 and another server behavior on your page that prevents you from editing the recordset when the other server behavior is on the page. You should be able to edit it and add the join statement in code view.

[Russell Collins]

Thanks Ray,

By editing in code view I'm able to inner join as I please.
I have been struggling with this for so long you wouldn't believe.

Your quality of service at WA is a benchmark.

Regards
Russell Collins

[fragop363190]

You can fix it up using Update's page do while code that the menu is using ofc not for posting the option field but for parsing between 2 recrodsets. i did it like that.

I don't know which approach is faster and which uses more resources though.