taicho
Registered Abuser
- Local time
- Yesterday, 18:21
- Joined
- Dec 13, 2005
- Messages
- 24
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 new database I am making I wanted to have one table that has these field.
The tables name currently is "Main", fields are as follows:
MainID (Primary Key)
PartNumber
PartDescription
VendorID
UnitAmount
CurrentPrice
Notes
ApprovedBy
ApprovalNumber
ReasonForChange
and then I have a "Prices" table which stores the different price changes for each part number:
PriceID (PKey)
PartNumber
Price
PriceChanged
now I what I am trying to do is have the "Main" table pull all the part numbers and their descriptions from the Unified Parts Table which is a linked table and I am not sure how to get it to fill all this stuff automatically inside a table not a form, would a "Main" Query be the correct way to go and completely skip the "Main" table??
Brain hurt......
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 new database I am making I wanted to have one table that has these field.
The tables name currently is "Main", fields are as follows:
MainID (Primary Key)
PartNumber
PartDescription
VendorID
UnitAmount
CurrentPrice
Notes
ApprovedBy
ApprovalNumber
ReasonForChange
and then I have a "Prices" table which stores the different price changes for each part number:
PriceID (PKey)
PartNumber
Price
PriceChanged
now I what I am trying to do is have the "Main" table pull all the part numbers and their descriptions from the Unified Parts Table which is a linked table and I am not sure how to get it to fill all this stuff automatically inside a table not a form, would a "Main" Query be the correct way to go and completely skip the "Main" table??
Brain hurt......