Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo
Message
De
22/04/2004 07:31:42
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
08/04/2004 08:30:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Combo
Divers
Thread ID:
00893230
Message ID:
00897153
Vues:
21
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform