Jason,
I feel I can give sone generic idea how to work with these things. Obviously, the way you were induced is workable but it's bad. There is no any necessity to use views for populating combos. The normal approach is that you populate next combo from current combo interactivechange event using Select-SQL statement:
***current combo interactivechange event
nSelectedValue=Val(This.Value) && assuming that it's character, and you use integer keys
Select nextname,nextid From nexttable Into Cursor tmp1 Where thisid=nSelectedvalue
Select tmp1
nCounter=0
Scan
nCounter=nCounter+1
this.parent.nextcombo.addlistitem(tmp1.nextname,nCounter,1)
this.parent.nextcombo.addlistitem(alltrim(str(tmp1.nextid)),nCounter,2)
EndScan
This is transparent clear way. Obviously, if you have many items (e.g. 100) you may just base your nextcombo on the cursor.