Hi Rick.  I've watched the courses from the Beginner Level 1 up to the Access Expert 2010 and I like how easy it is to follow the concepts and steps.  I've worked with Access before but using this as a refresher.

My question relates to planning/setting up my database and tables.  

I have an enormous excel spreadsheet of product types and the cost if we make it, we buy it from our partner, or we buy it from a third party. We were updating this information in excel but I thought Access would be quicker and easier and we can run queries from this.  I'm struggling even more on figuring out how to break the information into tables that would be the most effective for what we need.  Initially I thought I needed a product table and then a product cost table for each source but it seems that perhaps I should have a product table (with no cost) and then a cost table for each of the sources.  The cost tables would be the ones updated as prices change.  Your feedback is appreciated.

Thanks
Sheryl R

---

Reply from Alex Hedley:

Sounds good to me, then you have a historic list of what the costs were