I've two dropdown lists, each source to their own view. The second dropdown list's view's view Parameter is the id of the first list's currently displayed value. I requery the second view when the 1st dropdown value is changed by the user. If the user selects a value whose child table - sourced to dropdown 2 - has fewer records than the previous one the refresh of list 2 gives the record out of range error. I know there's a trick that's probably in the Hacker's Guide to VFP but I haven't got that.

I have a feeling that I should change a pointer in the second list but have not figured out where or what yet.

Can anyone help me here?

Thanks