2 remote view cursors to populate comboboxes

[steinkebunch]

I created two cursors from remote data, and would like to populate comboboxes on my form with these cursors. I can see both cursors in the Datasession window, but according to VFP help, these cursors are not opened in the work area.

The rowsource of of each comboboxes reads as follows:

Combobox1:

select * from cursor1

Combobox2:

select * from cursor2

When running the form, one combobox populates fine, the other generates a "Cannot access the selected table" error. Is it that VFP does not see the second cursor? I tried adding a

select cursor1

or

select cursor2

statement to each comboboxes init method. That did not help.

Any suggestions? Thanks in advance.

 

[rgbean]

Instead of re-Selecting these records for the Comboboxes, just make sure both have the property "Style" set to "2 - Dropdown List". Set the "RowSourceType" to "6 - Fields", and then set the respective "RowSource" to "cursor1.field1, field2, field3" and "cursor2.field1, field2, field3" (I'm obviously assuming three fields per cursor).

Rick

 

[steinkebunch]

Thanks for your help. Your suggestion solved the problem.

Steinkebunch