Hi,
I am trying to create a lookup query so people can review the results of their race finishes. I have a current text file attached with the table I think I need to build, but I am not sure how to display it correctly in a table when the query is run.
I am planning to give them drop down boxes to choose the year they want to see with the race class they want to review or all classes and races for the year if they want.
I can't figure out how to show the table so the race location will be on the top row and the rider name and result on the next row. It will work unless someone doesn't participate in a race. Then it throws the <TD> off one column if the rider did not participate.
Any suggestions including redisigning the table would be aprreciated.
Thank You,
Gary
See attached array.txt file for a view of the table layout and approximate HTML Layout.
