Post by mick on Jul 9, 2023 9:31:13 GMT
Here is what I used to turn those PDFs into.
Three tables, Race, Dogs and Dogform.
Copied a line from each at the same date into text form, hope it makes sense. Obviously it will not fit the page in one line
When in use I link the tables by location, date race number and for the form by dog name.
Race table
rRDate rRTcode rtAbbrev C_Day RRno RRName RDis Jump RRClass RStake trcCond firstStarters dayofweek
2/06/2023 THE GARDENS TGAR NO 10 BLUE GUM MEN'S SHED 400 6:11 PM 5 2310 GOOD 0 Friday
=============================================================================================================================================
2/06/2023 THE GARDENS TGAR NO 10 BLUE GUM MEN'S SHED 400 6:11 PM 5 2310 GOOD 0 Friday
=============================================================================================================================================
Dog table
dDate dTcode dAbbrev Country_day dRno dTabNo DogName fiForm getaway tdBesttime tdbestSplit Box Trainer hfirstname hsurName odds win_plcRatio totStarts totWins totSec totThrd Tds Tdw TdSec TdThrd Days WinPerc PlPerc DistWin boxStart boxWin boxPlace PrizeWon Dogtype Breeding
2/06/2023 THE GARDENS TGAR NO 10 8 ATTACK A WHACKER 42254 FM 23.21 11.25 8 Lisa Hutton Lisa Hutton 6 7.3 34 1 6 7 0 0 2 3 7 3 41 <400 400+ 500+ 600+ 700+ - 0 1 0 0 0 4 3 4 3 5 6 3 6 0 0 0 0 0 0 0 1 3 2 0 1 3 2 1 1 6130 Blue B Born Jul-20 Zipping Garth-Heart Attack
=========================================================================================================================================================================================
dDate dTcode dAbbrev Country_day dRno dTabNo DogName fiForm getaway tdBesttime tdbestSplit Box Trainer hfirstname hsurName odds win_plcRatio totStarts totWins totSec totThrd Tds Tdw TdSec TdThrd Days WinPerc PlPerc DistWin boxStart boxWin boxPlace PrizeWon Dogtype Breeding
2/06/2023 THE GARDENS TGAR NO 10 8 ATTACK A WHACKER 42254 FM 23.21 11.25 8 Lisa Hutton Lisa Hutton 6 7.3 34 1 6 7 0 0 2 3 7 3 41 <400 400+ 500+ 600+ 700+ - 0 1 0 0 0 4 3 4 3 5 6 3 6 0 0 0 0 0 0 0 1 3 2 0 1 3 2 1 1 6130 Blue B Born Jul-20 Zipping Garth-Heart Attack
=========================================================================================================================================================================================
Form table
fDogName fDate fVenue nswUniTrc Trainer ffirstName fsurname Fin BoxNum Marg lTime winTime bonTime fSectional sSectional LClass myRanking lStake lDist Odds time_perM lWgt Inrun lastWinSec gStake gAgedStake gDogtype gSire gDam gStarts gWins gSecs gThrds gTrainer Tier3 gRanking gWhelped gAge
ATTACK A WHACKER 26/05/2023 GRDN TGAR Lisa Hutton Lisa Hutton 4 8 3 16.22 16 15.69 4.67 0 5 58 0 272 12 0.0596324 27.3 6744 She Kissed Me 0 0 0 0 0 No 0 0
===============================================================================================================================================================
fDogName fDate fVenue nswUniTrc Trainer ffirstName fsurname Fin BoxNum Marg lTime winTime bonTime fSectional sSectional LClass myRanking lStake lDist Odds time_perM lWgt Inrun lastWinSec gStake gAgedStake gDogtype gSire gDam gStarts gWins gSecs gThrds gTrainer Tier3 gRanking gWhelped gAge
ATTACK A WHACKER 26/05/2023 GRDN TGAR Lisa Hutton Lisa Hutton 4 8 3 16.22 16 15.69 4.67 0 5 58 0 272 12 0.0596324 27.3 6744 She Kissed Me 0 0 0 0 0 No 0 0
===============================================================================================================================================================
