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 structure..." followup
hope i explain this well. i have a similar setup, as below, 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)? the one main issue i am having with the seperate table is to be able to edit the tracking table but still have the avialability to track any period at once. "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 |
#2
|
|||
|
|||
"need good structure..." followup
I think your MachineCounter table -
MachineCounter -- - MachineID - Date (date/time?) - IN - OUT neds to be like this - MachineCounter -- - MachineID - IN (date/time) - OUT (date/time) But I need to know how you define the Financial Period. -- Build a little, test a little. "tighe" wrote: hope i explain this well. i have a similar setup, as below, 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)? the one main issue i am having with the seperate table is to be able to edit the tracking table but still have the avialability to track any period at once. "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 |
#3
|
|||
|
|||
"need good structure..." followup
Karl,
Financial Period, is technically one calendar month, but the tracking may occur before, during, or after that period. we also may be working on multiple periods for a certain client as once. each item will be tracked in all periods. my biggest block is making sure that the period is recorded for when it has been tracked. "KARL DEWEY" wrote: I think your MachineCounter table - MachineCounter -- - MachineID - Date (date/time?) - IN - OUT neds to be like this - MachineCounter -- - MachineID - IN (date/time) - OUT (date/time) But I need to know how you define the Financial Period. -- Build a little, test a little. "tighe" wrote: hope i explain this well. i have a similar setup, as below, 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)? the one main issue i am having with the seperate table is to be able to edit the tracking table but still have the avialability to track any period at once. "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 | |
|
|