Portal w/ Conditional Value List NOT working, please HELP!
I'm probably missing something quite simple, but I've been working on this for two days!
I'm using SQL as a backend, so global fields in the parent table aren't possible (unless you know something I don't, which is quite probable)
I had it working once (several weeks ago), but something got messed up & I can't figure it out. I need a portal that will use a conditional value list. The conditional value list doesn't seem to be available unless the portal row has been commited first.
I have a STUDENT table/layout with a ACTIVITIES_Items table/portal. In the portal, I want to choose from a value list of EVENTS, but only those that are currently 'active'.
I've attached the file, but I don't think I can fully explain it. I need a conditional list, I can get the regular list, but the conditional one keeps coming up "no values." I can get the list to list as a portal, but not a Conditional list. ARGH! Please help.
P.S. - Please speak slow & clear, I'm a rookie.