This project requires a table to contain multimedia content about an
event. A set of consecutive numbers will display the content from this
record. I will be given the beginning and ending number for each record
and the text, image, video, and sound file(s). First what would the best
way to store the two numbers for the quickest lookup? Should I make the
beginning number the primary key? Next what is the best asp code to do the
query to find the right record when a user enters a number. For
background, the number will represent an hologram number on a sports
memorabilia item. This item will be one of a number of items signed by a
sports star at an event. All item numbers in the range will pull the same
content record to be displayed, the actual signing multimedia content.