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 6 1018
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******@pcdata sheet.com www.pcdatasheet.com
"David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message
news:c6******** **@newsg3.svr.p ol.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
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.sp am> wrote in message
news:cL******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com www.pcdatasheet.com
"David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message news:c6******** **@newsg3.svr.p ol.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,
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
TblAnimalInGrou p
AnimalInGroupID
AnimalID
GroupID
GroupInDate
GroupOutDate
TblGroupInField
GroupInFieldID
FieldID
GroupID
FieldInDate
FieldOutDate
Steve
PC datasheet
"David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message
news:c6******** **@news7.svr.po l.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.sp am> wrote in message news:cL******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com www.pcdatasheet.com
"David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message news:c6******** **@newsg3.svr.p ol.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
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.sp am> wrote in message
news:Te******** **********@news read3.news.atl. earthlink.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
TblAnimalInGrou p AnimalInGroupID AnimalID GroupID GroupInDate GroupOutDate
TblGroupInField GroupInFieldID FieldID GroupID FieldInDate FieldOutDate
Steve PC datasheet "David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message news:c6******** **@news7.svr.po l.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.sp am> wrote in message news:cL******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com www.pcdatasheet.com
"David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message news:c6******** **@newsg3.svr.p ol.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,
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***@hoofprin tnospam.fsnet.c o.uk> wrote in message
news:c6******** **@news7.svr.po l.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.sp am> wrote in message news:Te******** **********@news read3.news.atl. earthlink.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
TblAnimalInGrou p AnimalInGroupID AnimalID GroupID GroupInDate GroupOutDate
TblGroupInField GroupInFieldID FieldID GroupID FieldInDate FieldOutDate
Steve PC datasheet "David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message news:c6******** **@news7.svr.po l.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.sp am> wrote in message news:cL******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com > www.pcdatasheet.com > > > "David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message > news:c6******** **@newsg3.svr.p ol.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 > > > >
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.sp am> wrote in message
news:7s******** *********@newsr ead2.news.atl.e arthlink.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***@hoofprin tnospam.fsnet.c o.uk> wrote in message news:c6******** **@news7.svr.po l.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.sp am> wrote in message news:Te******** **********@news read3.news.atl. earthlink.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
TblAnimalInGrou p AnimalInGroupID AnimalID GroupID GroupInDate GroupOutDate
TblGroupInField GroupInFieldID FieldID GroupID FieldInDate FieldOutDate
Steve PC datasheet "David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message news:c6******** **@news7.svr.po l.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.sp am> wrote in message > news:cL******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com > > www.pcdatasheet.com > > > > > > "David" <Da***@hoofprin tnospam.fsnet.c o.uk> wrote in message > > news:c6******** **@newsg3.svr.p ol.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 > > > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Hans-Joachim Widmaier |
last post by:
Hi all.
Handling files is an extremely frequent task in programming, so most
programming languages have an abstraction of the basic files offered by
the underlying operating system. This is indeed also true for our language
of choice, Python. Its file type allows some extraordinary convenient
access like:
for line in open("blah"):
handle_line(line)
|
by: Ritz, Bruno |
last post by:
hi
in java i found that when a method has a throws clause in the definition,
callers must either handle the exceptions thrown by the method they are
calling or "forward" the exception to the caller by specifying a throws
clause as well.
is there a similar machanism in c++? i want to force a developer to write
handlers for all possible exceptions a method of my class library can throw.
|
by: Tim Nelson |
last post by:
**** Post for FREE via your newsreader at post.usenet.com ****
I am a newbie try to port my applications to Postgres. I have an
application that is bulk loading a table with autocommit off (with it on
it's way to slow). The logic of the application dictates that I try the
insert, and if it fails because of a duplicate, update the record instead.
The entire bulk load is wrapped in a transaction for speed purposes. When I
hit a...
|
by: Liz |
last post by:
I have a table of about 10,000 records where each record has a numeric field
named RecIdent. The value of RecIdent starts at 1 and is not sequential. For a
given RecIdent, there may be only one record with that value or there could be
multiple records with the same value. A sample of records looks like:
PK RecIdent
1 1
2 3
3 3
4 5
|
by: BlackFireNova |
last post by:
I have an Access 2003 mdb which contains software records. I need to
sort on a particular type of software, and then identify and count how
many copies there are per each group of that type purchased on the same
date.
I have no trouble doing a query to extract the type (say MS Excel 2002,
for example). The trouble is, there could be 50 copies purchased on
date "x", 80 copies purchased on date "y", and 250 copies purchased on
date "z",...
| |
by: David |
last post by:
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.
|
by: Ashok Kumar K |
last post by:
Hi all,
Where can I get some insight on using the __hook, __unhook, event_source and
event_receiver for specifically COM events. The documentation given in MSDN
is very minimal. I have the following scenario
Server (COM event source) is written in VC++ 6.0 using ATL (event interfaces
can be either dispinterface / IDispatch based)
Client (COM event receiver) is written in VC++ 2003 using attributed
programming and unified event handling
|
by: athos |
last post by:
Hi guys,
Got a problem now :( please help...
now we got a project handling records saved in a table in a sql
2000(will upgraded to 2005 soon) server. every month around a million
records will be inserted.
now user raised a request, that is, once criterios are matched, the
project should do some backend handle, for example, if
|
by: Bry |
last post by:
I've created a class that offers an enhanced way of handling fatal
exceptions. The class allows the user to optionaly submit a http based
anonymous error report to myself, and also records details in the
application log. The static method is overloaded, and supports passing
exceptions and/or strings just like throwing an exception.The class
will also fall back to the standard exception handling if something
goes wrong in my class.
As an...
|
by: mjay83 |
last post by:
I got 3 groups in my crystal report with few records with 1 field name QtyOrdered
How do I calculate number of records with QtyOrdered= 0 and show it in the end of each group
I written out the formula as:
Numbervar Zero;
if {StockOnHandOrderPlaced.QtyOrdered} = 0 then
(Zero:=Zero+1)
It calculating all records which is not according to groups, how do i change the formula so it can calculate group's record?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |