Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>Oh great gods of Foxpro... ;^)
>>
>>I need a bit of advice (what's new??). I'm using VFP v3.0 and I have several dropdown combo boxes in my form for several fields, i.e. vendor, system type, operating system. I need to create multiple relations between two tables so the proper values display on the forms. Here are the details:
>>
>> SYSTEM.DBF ALLCODES.DBF
>> ---------- ------------
>> vendorid codetype
>> systypeid id
>> opersysid displayvalue
>> ..etc.
>>
>>I need to relate System.vendorid with Allcodes.id and display only Allcodes.displayvalue where Allcodes.codetype='vendor' in one combobox, relate System.systypeid with Allcodes.id where codetype='systype' in another combobox and so on.
>>
>>I've taken your advice (including reading the help info in the UT's knowledge base section) to manually create my relations in my form's Load method rather than doing so in the data environment, but I am not sure what's the best way to create these multiple field relations in my forms.
>>
>>Also, I want the comboboxes to display the value which is currently in my System.dbf, but allow the users to select a different value from the Combobox which will then be saved back in my System.dbf. I know this is basic stuff, but my piles of manuals and magazines surrounding me offer only tidbits, and no real substance ;)!
>>
>>Your thoughts???
>>
>>mtia,
>>Mandy
>
>probably not what you're looking for, but...
>we use cursors for the recordsource for each combo box.
>in the lostfocus event of the first combo box, we requery the second combo box with 'where keyval = value of first combo box'.
Sounds a bit funky, but I'll give it a try. Thanks.
Mandy
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement