Using Data from one table to add information to another table.

C

crallen10

My database has several tables. I would like to be able to use the data from
the Vendor table to fill in the same fields in the current Orders form (and
Orders table) by entering the vendor ID# in Order Form.
 
D

Duane Hookom

You normally would not store duplicate data values. I you have the Vendor ID,
you should be able to always use the additional vendor information in queries.

If you really feel like you want to go through the trouble of storing
duplicate data, you can use the After Update event of the VendorID combo box
on a form to push values to other bound controls. This would require your
combo box to include all of the columns/fields you want to store in your
orders table.
 
Top