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: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Davey H
Sent: Tuesday, October 25, 2011 6:14 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] primary keys and relationships
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]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar