Business Problem-Please Help

[August Hasse]

Hello to all.

I need to design a database for tracking a supplier's
prices. I order items from them on an as needed basis
but there are hundreds of them. Basically I would be
working with a part number, a description, a date and a
price. What I would like to do is enter all past
invoices by typing the part number (which will occur many
times throughout many invoices). This would bring up a
box (record?) that would have the description (which only
needs to be entered once as it will remain the same for
each individual part number). The only other parameters
that would need to be entered are the date and the
price. I would do the same as new invoices come in.
Again, the goal of this is to track price increases over
time for individual items. When I wanted to check the
prices of a particular item I would like to type in the
part number and have it bring up all of the dates and
prices of that particular item.

Could someone suggest a plan for this idea? Is Access
the right program to use?

Any help would be greatly appreciated.

Thank You.

AH

 

[Cheryl Fischer]

August,

I would suggest two tables:

tblParts
PartNum (Primary Key)
PartDesc (description or name of part)

tblPrices
PriceID (AutoNumber)
PartNum
PartPrice
EffectiveDate

Also, for data entry and management, I'd recommend a Main Form - Sub Form
setup. The Main Form would be based on tblParts and the Sub Form would be
based on tblPrices. The Main and Sub forms would be linked via the
PartNum field.


hth,

 

[PC Datasheet]

August,

I can set this up and have it up and running for you in a short time for a very
reasonable fee. If you would like my help, contact me at the email address
below.