Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo
Message
From
22/04/2004 07:31:42
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
08/04/2004 08:30:23
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Combo
Miscellaneous
Thread ID:
00893230
Message ID:
00897153
Views:
17
>I would like to allow my users to first select which company they would like to process reports for. The selection is a combo box, dropdown. Based off the company, I would like for my users to select from a list only those personnel within that company who they want to runreports for. Can anyone assist?
*Form.init
with this.cboCompany
 .RowSourceType = 3
 .RowSource = 'select Company, CompanyID from Companies'+;
              ' order by Company'+;
              ' into cursor crsCompany'
 .Style = 2  
 .ListIndex = 1
endwith

with this.lstPersonnel
 .RowSourceType = 3
 .RowSource = 'select PersonName, PersonID from Personnel'+;
              ' where CompanyID == crsCompany.CompanyID'+;
              ' order by PersonName'+;
              ' into cursor crsPersonnel'
endwith

*cboCompany.InteractiveChange
with thisform.lstPersonnel
  .Requery()
  .ListIndex = 0
endwith
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform