cascading combos- continuous forms

I know there are many posts out there addressing this issue, but I have
yet to come across a complete solution. I have three separate
lookuptables and a junction table that link all those values.

I would like to show these in a continuous form because it is a data
entry form and would make the form much more user friendly for my uses.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11264-cascading-combos-continuous-forms.html


As is stated elsewhere, the values dissappear when you change records
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11264
if it is pulling from a different row source. Is there a way to keep
the values visible. So far I can only make the values stay visible if
I use a column count of 1 and only show the Autonumber index and not
the relevant value.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!