need good database structure for tracking counter state

[akioki]

Dear,
Can anyone help me to make good database structure?

What i have are some locations where I have some machines. Every machines
have 2 counters (IN and OUT). I need to be able to enter state of that
counters and after that to compare that values with previous entry IN and OUT
counters.

How I see it seams that somewere I need to keep information wich machine is
on wich location. Beside that I need to track information about date and time
of entries.

Situation:

Location 1 -> machine1, machine2, machine3
Location 2 -> machine4
Location 3 -> machine5, machine6, machine7, machine8
.....

I need 3 kind of reports:
â—‹ Deference between new IN / OUT and some old IN/OUT counters for every
machine
â—‹ Total IN/OUT for some location
â—‹ Total IN/OUT for all location

How I need to organize this datas?

Thanks for helping me,
akioki

 

[XPS350]

Dear,
Can anyone help me to make good database structure?

What i have are some locations where I have some machines. Every machines
have 2 counters (IN and OUT). I need to be able to enter state of that
counters and after that to compare that values with previous entry IN andOUT
counters.

How I see it seams that somewere I need to keep information wich machine is
on wich location. Beside that I need to track information about date and time
of entries.

Situation:

Location 1 -> machine1, machine2, machine3
Location 2 -> machine4
Location 3 -> machine5, machine6, machine7, machine8
....

I need 3 kind of reports:
        ○ Deference between new IN / OUT and  some old IN/OUT counters for every
machine
        ○ Total IN/OUT for some location
        ○ Total IN/OUT for all location

How I need to organize this datas?

Thanks for helping me,
akioki

It seems to me you need thre tables.

Location
- LocationID
- LocationName
..
..
..

Machine
- MachineID
- LocationID
..
..
..

MachineCounter
- MachineID
- Date (date/time?)
- IN
- OUT

Groeten,

Peter
http://access.xps350.com

 

[tighe]

Peter,

hope i explain this well. i have a similar setup but for the
"MachineCounter" table i have a finacial period. this period is essentially
a month, but items can come be in/out in the period before or after but it
still needs to be tracked in that period, so today i, may 5, i might recieve
something for the period of April. how do i do this? also i am truly
tracking three types of in/out, would it be better to have each item to track
be a seperate table and when it is tracked the system auto adds the Period
for each record in the seperate table(s)?