I have been using excel to do a weekly database for a logging company. Each week I deal with 2 or 3 crews that harvest timber on 2 to 4 different tracts of timber. I have 9 columns that I enter data into either manually or by macro or formulas. I am dealing with loads of timber that are harvested and hauled to a mill for processing. In my database I enter the Date, Destination or Mill, the Mill ticket number, the tract of timber that the timber was harvested from, The product or type of timber hauled, the volume in tons for each load, the price that the mill pays for that product per ton, the total paid for the load of timber, and the name of the truck driver.
I have recently bought access 2000 and would like to start to convert to access so that I could retrieve data more easily. I have used access a little in the past. So I am familiar with the program. My problem is the best way to set up the tables for the long haul. Each mill doesn't process all the products that I deal with. Different mills process different types of timber. They have a price that they will pay for those types. This price will go up and down as the market fluctuates. Finally, my question. Do I need to set up a table for all the products that I deal with, another that lists the mills, and another table for the prices or could they be combined into one or two tables? I would like to be able to enter the mill name, the product name, and the volume and have the price paid entered automatically based on those entries. I will also need to multiply the volume times the price but right now I want to try and set up the tables the best way and not have to re-do them later I know this is long but I would appreciate anyone pointing me in the right direction. Thanks Harold
