I have an enumeration table that includes 2 fields (each field has unique
values) called Common_Name and Scientific_Name.
In my form, I am using combo boxes that lets the user select a name from
each of the fields listed above.
What I want to do is if the person populates the combo box for Common_Name
it will automatically populate the combo box for Scientific_Name, and if
the
person populates the combo box for Scientific_Name it will automatically
populate the Common_Name combo box.
Thanks for the help
