Connecting Cells/Fields

[razor23]

Hello,

how do you connect fields from one table to another? what im trying to do is to connect two fields from product! product id and order details! product id. the one in the order details table should equal whatever i input in the product table.

 

[Rabbie]

Read Access help for relationships

 

[ajetrumpet]

from product! product id and order details! product id

This quote of yours leads me to believe that you are trying to reference a form maybe?? Are you trying to populate something on data entry, like the other table??

 

[razor23]

yes something like a reference so when i input a number in the product id field in the product table, it would also show in the order details table.

 

[ajetrumpet]

My suggestion is...don't do it this way. I am thinking that you want to do this because you have orders comming in for products you do not have entered in the system yet.

The best way (I think) to coordinate order details and product info is to auto-populate the "order details" information on an order entry form from the information that you have already stored in the "product details" recordset.
You can set any kind of reference you want really in most form controls.

I don't see why you want to automate this way, I see headaches down the road with it. I don't really see why you should ever have to do it this way...

 

[neileg]

It's difficult to advise without a bit more information about what your tables represent and what you are trying to do.

Typically, you would handle order details in a form/subform setup. Selecting products could be done using a combo box set up.