Hi,

I'm setting up a database of courses and related information (levels, times, fees, etc.) and I am looking for some design advice.

I want the user to be able to input the following -

Courses: 1 - 50 (anywhere from one course up to fifty courses).

Levels: 1 - 20 per Course.

Times: 1 - 10 per Level.

Fees: unlimited combinations for the above Courses/Levels/Times.

I know how to set up the relational tables but I am concerned about the number and layout of html forms that will be needed to collect the information. Unless I'm missing something the user will need to complete hundreds of fields or forms to cover every combination.

Could someone please explain how best to set this up so the users time is kept to a minimum?

Thank you.

Simon.