hi everyone
am an access newbie so still finding my way around things.
i have a database with two related tables "suppliers" and "purchases". suppliers has a "supplier id" primary key with another field called "supplier name" in it. purchases has a "purchase id" primary key with another field called "supplier id" which is one-to-many related to the the supplier id field in suppliers with referential integrity enforced and cascade update related fields.
i now have a form for the purchases that displays the information and where users can update the data. the form is set up to include all the info from the purchases table and the supplier id and supplier name from the supplier table as the record source.
when i display all the fields, i would like to be able to list in a combo box the suppliers names, which when each particular one is selected updates the appropriate "supplier id" in the purchases table.
at the minute, all i can do is get it to either display the "supplier id" numbers which when selected will update the supplier id field in purchases, or if i set it up to display the names that can be selected, when i select a name all it does is update the suppliers table, and not the suppliers id keys in the purchases table!
any ideas? thanks!