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

[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

 

[PC Datasheet]

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.

 

[Davey]

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?

 

[John Vinson]

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?

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.