Prev: Text Field Validation Rule for Date
Next: Table Help
From: tighe on 3 May 2010 17:36
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 <aki...(a)discussions.microsoft.com> 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
> .
>
 | 
Pages: 1
Prev: Text Field Validation Rule for Date
Next: Table Help