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:
i then have an order detail table that has the following fields:
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?