>Dear ppl,
> I am working on a personnel database in VFox 6 and I want to create a combobox inside a form based on information stored in another tabled databased... is there a way to do that? if yes, can u give me some simple instructions?
>Thankx
>Tom
Tom,
Set your rowsourcetype to 3 (SQL) and put your SQL expression in RowSource. Adjust Columncount to your desire (1 to fcount() in SQL) and Columnwidths like '100,50,40' (3 columns).
If value selected would change a field value in a table then specify what field value would be stored to which one. ie:
* SQL
select departmentname, deptid from depts into cursor crsDepts
* Target
personnel.deptid
Then set BoundTo = .t., BoundColumn = 2 and controlsource = 'personnel.deptid'
Cetin