Search results

Ok so here is the problem I need help with, I have a prices table that stores all the different price changes for each part I have in my Parts table what I need to figure out how to do is to copy the "Last" price for that part from the price table into the Price field of the Parts table or have...

Another idea... I was also thinking of making the Main Query from the "Unified Parts Table" and the "Main Table" to merge the data/fields from "Unified Parts Table" and get the fields from "Main Table" then turning the query into a make-table query one time and then changing that same query...

Thanks for the reply :-D The reason I thought about creating the "Main" table was because it has some new fields which are not in my "Unified Parts Table/DB" but I was curious - when you say that if I need to use Main table it should have the PK of the linked table do you mean actually use the...

Hi, All I am designing a database to keep track of part prices and their trends, the part numbers and all their related information are stored in a "Unified Parts Database" containing all pertinent information about the parts, their vendor, current price, material, sub-material etc...Now in the...