Hi
I am trying to set up a small database for Horse Racing. I need to keep a database listing the details found in the racecard. The database will be used in to feed a caption generator which displays results, betting, racetitles etc over the CCTV on the racecourse. I am a complete novice and I am trying to find a way to create a autonumber generator for each horse in a race. The race will have it's own table but it's rather time consuming to keep putting in the number of the horse when it could be down automatically each time I save a record. I don't want to use autonumber in case I wan't to delete a record. I have scanned lots of sites and the propose using the DLast function in the before update properties of the form. Can someone give me a hand with the code. The Table is RunnersRace(Race No.) and the field is HorseNumber.
Thanks for any help
Frank Leggett