Getting info from 2 different tables and putting it into a third

  • Thread starter Thread starter Davey
  • Start date Start date
D

Davey

How can I set it up that In one from I will choose customers from one table
and in the same form choose product etc... from a different table, and then
store the fact that this customer purchased this product into a differnent
table? Thank very much
 
You shouldn't be storing customer names and product names in the third table.
Rather, create a form to add data to the third table and on the form have a
combobox for customer and a combox for product. The comboboxes should have
rowsources of TblCustomer and TblProduct respectively. The customer combobox
should have the value of CustomerID and the product combobox should have a value
of ProductID. When you make selections in the comboboxes, the form should save
CustomerID and ProductID in the third table.
 
Thank you. how i will later be able to look at thure is it possible for
youn to describe it to me clearer like in an actual example, since im
not sure how i can get it to save it into the third table if im pulling
it in from a different table?
 
Thank you. how i will later be able to look at thure is it possible for
youn to describe it to me clearer like in an actual example, since im
not sure how i can get it to save it into the third table if im pulling
it in from a different table?
Click to expand...

An example which does precisely what you describe is the Orders form
on the Northwind sample database - check your Access install CD
Samples folder, if Northwind wasn't installed automatically.
 
Back
Top