If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
need good database structure for tracking counter state
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 |
#2
|
|||
|
|||
need good database structure for tracking counter state
On 25 mrt, 13:24, akioki wrote:
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 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 |
#3
|
|||
|
|||
need good database structure for tracking counter state
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)? "XPS350" wrote: On 25 mrt, 13:24, akioki wrote: 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 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 . |
Thread Tools | |
Display Modes | |
|
|