Hi,

I have a selection window with two Comboboxes set as Dropdown List.
I would like to select a Branch Office from the 1st Combo and have its Loan Officers populate the 2nd Combo. Can this be done with two Combo boxes? I currently have Combo1 set as ControlSource = Brorder.cbranchnam; RowSource = Brorder.cbranchnam and RowSourceType = 2-Alias; Combo2 set as ControlSource = Loanoff.cloname; RowSource = Loanoff.cloname and RowSourceType = 2-Alias. I can seem to get it to work. Am I setting something incorrectly? My relationship seems to be correct when I test it using the datasession window.

I also have the following data environment:

OPEN DATABASE (.gcNetDir+"Dbfs\Loanlog.dbc") SHARED
USE (.gcNetDir+"Dbfs\Brorder.dbf") IN 0 ORDER BRID SHARED
SET FILTER TO Brorder.cbranchnam != "Terminated"

USE (.gcNetDir+"Dbfs\Loanoff.dbf") IN 0 ORDER LOFFID SHARED

SELECT Brorder
SET RELATION TO (Brorder.cbranchnum+Brorder.cbranchnam) INTO Loanoff ADDITIVE


I would appreciate any help.

Thank you