Hi Mark
I'm also creating a fantasy football competition. I am a 3rd year Multimedia student and it is an assignment for one of my units. The assignment requirements dictate that I use coldfusion with a Microsoft Access DB.
I have based it on our own A-League in Australia, foolishly thinking that a smaller league will be easier to create
Due to the restriction of time and talent I am currently focussing on the team selection process before the fixtures start. At the moment I have the following functionality:
Member Registration
Member Login
Customised Team page based on Favourite Team Selection
Trash Talk Forum (basic)
I have attached my DB relationship diagram. Hopefully this is correct and helps you out with your own project. Any thoughts?
My next step is to populate a team and join/create leagues. Any tips on how you have done this with your DB structure?
How are you travelling with your interactivity? My first thought for me was to use Flash, it which works well with coldfusion but thanks to Mr Jobs it won't work on Apple products...yet... so i'm trying to explore other techniques that I can use.
Cheers
Jay