The thing is, it needs to - ugh how can I 'splain this without a picture? hm...
VENDOR TABLE FIELDS
CHECK TABLE FIELDS
check_ven_id (FK - looks up a value in the ven_id field in the vendor table)
combo box that looks up vendor.ven_name
several text boxes that enter info into the check table (such as check amount and check number)
The problem is, when I put the vendor name into the combo box, the form complains because it can't match vendor.ven_id with any values in check.check_ven_id
I need it to automatically enter the appropriate vendor ID into the check.check_ven_id field as soon as the vendor name is selected in the combo box and I can't for the life of me figure out how to do this.
Wow that was wordy. I hope you guys can decipher it. It would be much easier to explain it if you could see it.