>>>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.
I don't see where nLevelID is initialized!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.