Handling groups of records

[David]

One of my farm livestock app customer wants me to tweak the system so he can
record where every animal
is, and has been while it was on his farm.
..
Example - heifer X was in top shed from 01/01/03 to 01/01/04 then west field
from 01/01/04 to 01/05/04 then etc etc

Cattle could be in groups of 30 or 40 but individual animals may not always be
in the same group.

So - Would appreciate thoughts on how best to to tackle this.

TIA
David B

[PC Datasheet]

David,

Your database should track when an animal changes groups and where each group is
every day. Then you can determine on any date what group an animal was in and
where that group was at. Knowing where the group was at gives you where the
animal was at.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@newsg3.svr.pol.co.uk...

One of my farm livestock app customer wants me to tweak the system so he can
record where every animal
is, and has been while it was on his farm.
.
Example - heifer X was in top shed from 01/01/03 to 01/01/04 then west field
from 01/01/04 to 01/05/04 then etc etc

Cattle could be in groups of 30 or 40 but individual animals may not always be
in the same group.

So - Would appreciate thoughts on how best to to tackle this.

TIA
David B

[David]

Thanks for the reply.
I had the concept figured out, I was looking for neat ideas on how to move
groups between
fields and move animals to a different group.
I am thinking the table for this will be something like

animalrecno
fieldid
groupno
indate
outdate

David B
PC Datasheet <sp**@nospam.spam> wrote in message
news:cL*****************@newsread2.news.atl.earthl ink.net...

David,

Your database should track when an animal changes groups and where each group is every day. Then you can determine on any date what group an animal was in and
where that group was at. Knowing where the group was at gives you where the
animal was at.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@newsg3.svr.pol.co.uk...

One of my farm livestock app customer wants me to tweak the system so he can
record where every animal
is, and has been while it was on his farm.
.
Example - heifer X was in top shed from 01/01/03 to 01/01/04 then west field
from 01/01/04 to 01/05/04 then etc etc

Cattle could be in groups of 30 or 40 but individual animals may not always be in the same group.

So - Would appreciate thoughts on how best to to tackle this.

TIA
David B

[PC Datasheet]

David,

I don't think your table will work; you're trying to use indate and outdate for
two purposes, moving groups from field to field and moving animals from group to
group. How about tables like these:
TblAnimalField
AnimalFieldID
AnimalFieldName

TblAnimal
AnimalID
AnimalNum

TblGroup
GroupID
GroupNum

TblAnimalInGroup
AnimalInGroupID
AnimalID
GroupID
GroupInDate
GroupOutDate

TblGroupInField
GroupInFieldID
FieldID
GroupID
FieldInDate
FieldOutDate

Steve
PC datasheet

"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@news7.svr.pol.co.uk...

Thanks for the reply.
I had the concept figured out, I was looking for neat ideas on how to move
groups between
fields and move animals to a different group.
I am thinking the table for this will be something like

animalrecno
fieldid
groupno
indate
outdate

David B
PC Datasheet <sp**@nospam.spam> wrote in message
news:cL*****************@newsread2.news.atl.earthl ink.net...

David,

Your database should track when an animal changes groups and where each group

is

every day. Then you can determine on any date what group an animal was in and where that group was at. Knowing where the group was at gives you where the
animal was at.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@newsg3.svr.pol.co.uk...

One of my farm livestock app customer wants me to tweak the system so he can record where every animal
is, and has been while it was on his farm.
.
Example - heifer X was in top shed from 01/01/03 to 01/01/04 then west field from 01/01/04 to 01/05/04 then etc etc

Cattle could be in groups of 30 or 40 but individual animals may not

always be in the same group.

So - Would appreciate thoughts on how best to to tackle this.

TIA
David B

[David]

Thanks for that Steve.
Have a few hours on the tractor today. Ideal for thinking these problems
through <g>
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:Te******************@newsread3.news.atl.earth link.net...

David,

I don't think your table will work; you're trying to use indate and outdate for two purposes, moving groups from field to field and moving animals from group to group. How about tables like these:
TblAnimalField
AnimalFieldID
AnimalFieldName

TblAnimal
AnimalID
AnimalNum

TblGroup
GroupID
GroupNum

TblAnimalInGroup
AnimalInGroupID
AnimalID
GroupID
GroupInDate
GroupOutDate

TblGroupInField
GroupInFieldID
FieldID
GroupID
FieldInDate
FieldOutDate

Steve
PC datasheet

"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@news7.svr.pol.co.uk...

Thanks for the reply.
I had the concept figured out, I was looking for neat ideas on how to move
groups between
fields and move animals to a different group.
I am thinking the table for this will be something like

animalrecno
fieldid
groupno
indate
outdate

David B
PC Datasheet <sp**@nospam.spam> wrote in message
news:cL*****************@newsread2.news.atl.earthl ink.net...

David,

Your database should track when an animal changes groups and where each group

is

every day. Then you can determine on any date what group an animal was in

and where that group was at. Knowing where the group was at gives you where the animal was at.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@newsg3.svr.pol.co.uk...
> One of my farm livestock app customer wants me to tweak the system so he can > record where every animal
> is, and has been while it was on his farm.
> .
> Example - heifer X was in top shed from 01/01/03 to 01/01/04 then west field > from 01/01/04 to 01/05/04 then etc etc
>
> Cattle could be in groups of 30 or 40 but individual animals may not

always

be

> in the same group.
>
> So - Would appreciate thoughts on how best to to tackle this.
>
> TIA
> David B
>

[PC Datasheet]

David,

You might consider using two multiselect listboxes to move animals from group to
group. The listboxes would work like the listboxes for the wizards where you
pick fields. On your form you would use a combobox to first choose the group you
want to move animals to.The left listbox would list all your animals and you
would build your list of animals to move to the selected group in the right
listbox. After you have built your list in the right listbox, you would have
code behind a button to move all the animals in the right list to the selected
group.

Something similar could be done to move groups to fields.

Steve
PC Datasheet
"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@news7.svr.pol.co.uk...

Thanks for that Steve.
Have a few hours on the tractor today. Ideal for thinking these problems
through <g>
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:Te******************@newsread3.news.atl.earth link.net...

David,

I don't think your table will work; you're trying to use indate and outdate for

two purposes, moving groups from field to field and moving animals from group to

group. How about tables like these:
TblAnimalField
AnimalFieldID
AnimalFieldName

TblAnimal
AnimalID
AnimalNum

TblGroup
GroupID
GroupNum

TblAnimalInGroup
AnimalInGroupID
AnimalID
GroupID
GroupInDate
GroupOutDate

TblGroupInField
GroupInFieldID
FieldID
GroupID
FieldInDate
FieldOutDate

Steve
PC datasheet

"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@news7.svr.pol.co.uk...

Thanks for the reply.
I had the concept figured out, I was looking for neat ideas on how to move
groups between
fields and move animals to a different group.
I am thinking the table for this will be something like

animalrecno
fieldid
groupno
indate
outdate

David B
PC Datasheet <sp**@nospam.spam> wrote in message
news:cL*****************@newsread2.news.atl.earthl ink.net...
> David,
>
> Your database should track when an animal changes groups and where each

group

is
> every day. Then you can determine on any date what group an animal was

in and

> where that group was at. Knowing where the group was at gives you where the > animal was at.
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
> re******@pcdatasheet.com
> www.pcdatasheet.com
>
>
> "David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
> news:c6**********@newsg3.svr.pol.co.uk...
> > One of my farm livestock app customer wants me to tweak the system so

he can

> > record where every animal
> > is, and has been while it was on his farm.
> > .
> > Example - heifer X was in top shed from 01/01/03 to 01/01/04 then west

field

> > from 01/01/04 to 01/05/04 then etc etc
> >
> > Cattle could be in groups of 30 or 40 but individual animals may not

always

be
> > in the same group.
> >
> > So - Would appreciate thoughts on how best to to tackle this.
> >
> > TIA
> > David B
> >
>
>

[David]

Thanks Steve.
I was thinking along those lines myself. So would the right listbox need to be
based on a temp table
or is there another way.
David

PC Datasheet <sp**@nospam.spam> wrote in message
news:7s*****************@newsread2.news.atl.earthl ink.net...

David,

You might consider using two multiselect listboxes to move animals from group to group. The listboxes would work like the listboxes for the wizards where you
pick fields. On your form you would use a combobox to first choose the group you want to move animals to.The left listbox would list all your animals and you
would build your list of animals to move to the selected group in the right
listbox. After you have built your list in the right listbox, you would have
code behind a button to move all the animals in the right list to the selected
group.

Something similar could be done to move groups to fields.

Steve
PC Datasheet
"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@news7.svr.pol.co.uk...

Thanks for that Steve.
Have a few hours on the tractor today. Ideal for thinking these problems
through <g>
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:Te******************@newsread3.news.atl.earth link.net...

David,

I don't think your table will work; you're trying to use indate and outdate

for

two purposes, moving groups from field to field and moving animals from group

to

group. How about tables like these:
TblAnimalField
AnimalFieldID
AnimalFieldName

TblAnimal
AnimalID
AnimalNum

TblGroup
GroupID
GroupNum

TblAnimalInGroup
AnimalInGroupID
AnimalID
GroupID
GroupInDate
GroupOutDate

TblGroupInField
GroupInFieldID
FieldID
GroupID
FieldInDate
FieldOutDate

Steve
PC datasheet

"David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
news:c6**********@news7.svr.pol.co.uk...
> Thanks for the reply.
> I had the concept figured out, I was looking for neat ideas on how to

move > groups between
> fields and move animals to a different group.
> I am thinking the table for this will be something like
>
> animalrecno
> fieldid
> groupno
> indate
> outdate
>
> David B
>
>
> PC Datasheet <sp**@nospam.spam> wrote in message
> news:cL*****************@newsread2.news.atl.earthl ink.net...
> > David,
> >
> > Your database should track when an animal changes groups and where each group
> is
> > every day. Then you can determine on any date what group an animal was

in and
> > where that group was at. Knowing where the group was at gives you where the

> > animal was at.
> >
> > --
> > PC Datasheet
> > Your Resource For Help With Access, Excel And Word Applications
> > re******@pcdatasheet.com
> > www.pcdatasheet.com
> >
> >
> > "David" <Da***@hoofprintnospam.fsnet.co.uk> wrote in message
> > news:c6**********@newsg3.svr.pol.co.uk...
> > > One of my farm livestock app customer wants me to tweak the system

so he can
> > > record where every animal
> > > is, and has been while it was on his farm.
> > > .
> > > Example - heifer X was in top shed from 01/01/03 to 01/01/04 then

west field
> > > from 01/01/04 to 01/05/04 then etc etc
> > >
> > > Cattle could be in groups of 30 or 40 but individual animals may not
always
> be
> > > in the same group.
> > >
> > > So - Would appreciate thoughts on how best to to tackle this.
> > >
> > > TIA
> > > David B
> > >
> >
> >
>