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