Question
Need some direction?
Here is my delema...I am designing/developing a site for a
event promotion company and I am kinda stuck as to what way to do
something. Actually 2 things. The 1st being the DB design. I have
done several dynamic sites before but never this involed. I am
using ASP and VBScript and access DB. Here is what I want to do.
Ok there are 4 events that all share basic traits. But things like dates, times and rules will change from event to event. What would the best structure be for the tables. 1 main table and then look up tables that house the static info? Hope that this makes sense.
2nd question how would I do this....all the events have race classes that range from 50cc to pro. But due to turn out some of the classes my not be offered at the events. So when editing the event I would like to offer all the classes that are on by default and the admin would have to uncheck the box to turn that class off for that event so it doesn't display on the web page. I know that this is going to have to be done dynamically but then that goes back to the 1st question of setting up the DB
Hope all this makes sense...any help or tutorials would be great..
thanks
B
Ok there are 4 events that all share basic traits. But things like dates, times and rules will change from event to event. What would the best structure be for the tables. 1 main table and then look up tables that house the static info? Hope that this makes sense.
2nd question how would I do this....all the events have race classes that range from 50cc to pro. But due to turn out some of the classes my not be offered at the events. So when editing the event I would like to offer all the classes that are on by default and the admin would have to uncheck the box to turn that class off for that event so it doesn't display on the web page. I know that this is going to have to be done dynamically but then that goes back to the 1st question of setting up the DB
Hope all this makes sense...any help or tutorials would be great..
thanks
B
AdChoices