Sorry for the delay in replying.
Firstly I am not using Raceform Interactive, and secondly much to my
embarrassment I have none the wiser what an
EDECS file is despite googling it. I'm afraid my knowledge isn't that
great.
I'd be grateful if you could explain what it is
Davey H
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...>
wrote:
>
> Hi Davey,
>
> Did you see my message 93900?
>
> If you upload a recent EDECS file I will test my
> old code to see if it runs OK with latest level.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Clive" zctek@ wrote:
> >
> > Hi Davey,
> >
> > Are you using 'RaceForm Interactive' ?
> >
> > I produced a File Converter to change an EDECS file into
> > a Runners File and a Riders File back in Access95 days.
> >
> > If you want to have fun and use Access to manipulate
> > the data then I will upload the File Converter to the
> > Access Files for you.
> > It may need tweaking if the EDECS format has changed
> > since I wrote it.
> >
> > If you want make money instead then read Tom Segal
> > (PriceWise) in the Racing Post <g>.
> >
> > Please let me know.
> >
> > Regards, Clive(Williams)
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Crystal
<strive4peace2008@> wrote:
> > >
> > > Hi Davey,
> > >
> > > did this come from an XML dump? It appears to be structured. I
see these tables ... and more ...
> > >
> > > Events
> > > - EventID, autonumber -- PK
> > > - EventName, text (ie: Saturday Races)
> > > - EventDate, date/time
> > >
> > > Courses
> > > - CourseID, autonumber, PK
> > > - CourseName
> > >
> > >
> > > Races
> > > - RaceID, autonumber, PK
> > > - RaceNo
> > > - CourseID
> > > - PrizeAmt
> > > - Winner
> > >
> > >
> > > Horses
> > > - HorseID, autonumber, PK
> > > - HorseName
> > > - hOwner
> > > - hDOB, date/time, date of birth
> > > - hAge, number, in case DOB is not available
> > > - hWeight, number
> > >
> > > - etc
> > >
> > > RaceHorses
> > > - RaceHorsID, autonumber, PK
> > > - RaceID, long, FK to Races
> > > - HorseID, long, FK to Horses
> > > - RunTime, date/time
> > >
> > > if prizes are trophies or something that revolves, you will need
to put PrizeID in the Races table
> > >
> > > Prizes
> > > - PrizeID, autonumber, PK
> > > - PrizeName, text
> > > - PrizeAmt, currency
> > >
> > > PK = Primary Key
> > > FK = Foreign Key
> > >
> > > for structure ideas, watch the videos in the Learn Access playlist
here:
> > > http://www.YouTube.com/LearnAccessByCrystal
> > >
> > > and read this book (especially Normalization and Relationships
chapters)
> > >
> > >
> > > Access Basics by Crystal (Bill Mosca's site)
> > > http://thatlldoit.com
> > > Free 100-page book that covers essentials in Access
> > >
> > > and get a couple good big reference books for Access such as a
book in John Viescas' signature ;)
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > *
> > > (: have an awesome day :)
> > > *
> > >
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: John Viescas
> > >
> > > Davey-
> > >
> > > Well, the data you pasted is almost impossible to read! If you
have a table for
> > > horses, then put the linking HorseID into the Results table to
link the result
> > > to the horse. In an Access form, you would use a combo box on
HorseID in the
> > > results form to pull in the horse names to make it easy to pick
the right ID.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Davey H
> > > Sent: Tuesday, October 25, 2011 s
> > >
> > > Even though I'm the wrong side of Cemetary Hill I joined the
computer
> > > revolution and taught myself Excel.
> > > My hobby is Horse Racing and I had been keeping the results in an
Excel
> > > File. However that has grown to a huge spreadsheet and I found it
very
> > > hard to learn how to extract the information needed.
> > > I therefore tried to learn Access but am finding it very difficult
to
> > > understand in places in particular keys and relationships. Below
are the
> > > tables. the HORSE table has ID as primary key but after that I'm
at a
> > > loss trying to decide primary and foreign key connections between
> > > tables.
> > > I would appreciate your advice.
> > >
> > > Many Thanks
> > > Davey H
> > >
> > > RESULTS DECS
HORSE
> > > RaceNo 466066 466080 RaceNo 1
> > > HORSEID HORSE Course DONC NEWB
Course
> > > ASCO 1 A B Celebration Date 21-Oct-11
> > > 21-Oct-11 Date 1/1/2011 2
A Boy
> > > Named Suzi Rtime 15:45 16:05 Rtime
14:00
> > > 3 A P Ling Go GD GF Go GD
> > > 4 A Pocketful Of Rye (IRE) Age 4 4
Furs
> > > 6 5 A Southside Boy (GER) Furs 6 10
> > > Class 4 Class 2 4
> > > Prize 1111 Prize £11,450
> > > £4,528 Horse A P Ling
> > > Ran 22 15
Pos
> > > 1 1 Drw
20
> > > 14 RACES Btn
2.25
> > > 0.1 RaceNo 466066 466080 466067 466081
> > > 466068 TBtn 2.25 0.1 Course
DONC
> > > NEWB DONC NEWB DONC Horse Bohemian
Melody
> > > Jiwen (CAN) Date 21-Oct-11 21-Oct-11
21-Oct-11
> > > 21-Oct-11 21-Oct-11 Wgt 122 129
> > > Rtime 15:45 16:05 16:20 16:40 16:55 OR
91 83
> > > Go GD GF GD GF GD GRD 105 81
> > > Age 4 4 4 3 4 WA 4 8
Furs
> > > 6 10 14.6 8 10.3 AA 0 0
> > > Class 2 4 4 5 4 PPL 2.95 1.77
> > > Prize £11,450 £4,528 £4,528 £2,588 £4,528
> > > RAW 102 85 Ran 22 15 18 12 19
> > > RAWadj 88 82 BHB 105 81 84 75 85
> > > BHB 107 81 WA 4 8 0 9 7
> > > BHBadj 89 70 AA 0 0 0 2 0
> > > HEAL 98 78
> > > ORADJ 80 72
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
Tidak ada komentar:
Posting Komentar