Table design help

[hockeylvr]

Can't get my brain wrapped around this one. I have three fields for different types of costs "Freight", "Insurance", "Packaging". I have a form with these text boxes which I need the following information for each type of cost:

Standard Cost
Plan Cost
Actual Cost
Plan Savings
Outlooked Savings

How can I design my table so that I don't have to create one field for each type? i.e.

Freight-Std Cost
Freight-Plan Cost
Freight-Actual cost
Freight-Plan Savings
Freight-Outlooked Savings
Insurance-Std Cost
Insurance-Plan Cost

and so on...

I will be setting up the form like this

StdCost PlanCost ActCost PlanSavings Outlooked

Freight $ $ $ $ $
Insurance $ $ $ $ $
Packaging $ $ $ $ $

Any ideas would be appreciated!

Toni

 

[PHV]

The simplest:
CostType
StandardCost
PlanCost
ActualCost
PlanSavings
OutlookedSavings

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

I see a table with three fields:
CostType (Freight, Insurance, or Packaging)
CostCategory (Std, Plan, Act,...)
Cost (currency value here)


Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[hockeylvr]

Thank you-I'll give your ideas a try!