How to setup table or tables?

[tmcnutt]

I have the following information that I need to track and I am not sure how to correctly define the table or tables. I have parts that have the following data: material cost, mechanical hours, electrical hours, engineering hours. What I want to do is be able to calculate total cost for a part based on material cost, mechanical hours * mechanical rate, electrical hours * electrical rate, engineering hours * engineering rate. Shouldn't I keep the rates in a different table? If you could please give me an example of how the table(s) should be set up and how I can query to find the total cost, I would greatly appreciate it.

Thanks,
Tom

 

[PHV]

Take a look here:

http://www.abcdataworks.com/fundamentals.htm

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