>>The RowSource for the second combo is
>>with .colSections.cboSections
>>
>> .rowsourcetype = 3
>> .rowsource = "select * from csrSections where LevelID = ?nLevelID into cursor csrSect"
>> .parent.controlsource = 'rsTSBlocks.SectionID'
>> endwith
>>
>>The Level should be the level from the first column selected value. Do you know the correct way to solve the problem? May be I should not try to restrict the sections at all?
>
>
>Why? You can restrict the user to choose only from right values.
>
>Is csrSections buffered?
>Maybe you need:
>
>... from csrSections WITH (BUFFERING=.t.) ...
>
No, this cursor is not buffered. BTW, I removed the where part and the problem was solved (well, I guess I will need to apply filter in got focus to only show sections for the current level).
Anyway, the last column's problem still remains.
If it's not broken, fix it until it is.
My Blog