Date: 05/28/06 (Code WTF)    Keywords: database

Heeelp!!! I'm making a database in Access and I have this form that retrieves a Vendor's name from the Vendor table.

The thing is, it needs to - ugh how can I 'splain this without a picture? hm...

VENDOR TABLE FIELDS
ven_id (PK)
ven_name

CHECK TABLE FIELDS
check_ven_id (FK - looks up a value in the ven_id field in the vendor table)

CHECK FORM
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.

Source: http://community.livejournal.com/code_wtf/40917.html