What is best method to track pricing of +40K unique items?

[Guest]

I am trying to track over 40,000 types of pharmaceutical drugs and their
change in cost month-to-month. What would be the best way to do this as well
as any data analysis?

 

[Smartin]

I am trying to track over 40,000 types of pharmaceutical drugs and their
change in cost month-to-month. What would be the best way to do this as well
as any data analysis?

I would start with two tables. First table has all the drugs,
descriptions, etc., but *no pricing*. Second table has a foreign key to
the drugs table, an effective date, and amount.

Does this help?

Sounds like a lot of data entry!