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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only