Re: Need a way to cycle through records

2002-01-23 Thread Jeffry Houser
This sounds like run of the mill stuff. A few comments: You are storing the names of the top 50 finishers in a race in a single row, if that is what you truly meant, that sounds like it must be violating some form of database design, although I don't know enough right now to make that dis

Need a way to cycle through records

2002-01-23 Thread Tim
I have a database of race results cover six years. The results table has a date field, race name field, and fields for the first 50 finishers. I also have a race name table and a racers table. The fields in the results table are populated with the corresponding key fields for the race and runne