MS access send data from table 1 to 2

I have created a database for a university assignment and it is for a dummy company that sells computer parts.

Basically i have a product table that has the following fields:
product id(primary)
prod manufacturer
modelnumber
description
price
additional info
stock
supplierID

i then have an order detail table that has the following fields:
orderID (primary)
customerID
sale number
productID
modelNumber
description
quantity
price

I want the table so that everytime i put a productID in the order table the model number, description,and price updates.

I can only have the primary key with a relationship.

can anyone help please?