reference based on common number

[LoneReaper]

i am making a invoice form. i have 2 tables, a "orderfulfiment" table which has the customer info and the sku, title, and price of the item they ordered. I also have a "book" table that includes all book info like sku, title, price, NOTES, AUTHOR, etc...

on my form i have the sku, title and price text boxes that are referenced to the "orderfulfiment" table, how do i get the "Notes" field from the "book" table to be shown on the form. the reference if needed can be the sku number

 

[Mile-O]

You have unnecessary fields in your order table. If you store the primary key of the book in the order table (as a foreign key) then the other details relating to the book can be brought together via a query.

 

[LoneReaper]

problem

i download the info in the orderfulfilment table from amazon.com so i decided to keep all that info just incase i needed it at some point. lets say i set the primary key to the sku number, how would i get the information into the orderfulfiment table?