Hi Craig
Thanks for the interest.
It's only on localhost at the moment, however, I will try to explain;
Currently, I have a page to 'add officers' - there are 20 'posts', such as treasurer, secretary, xxx cttee chairman, yyy cttee chairman, etc.
On the existing page, I select the appropriate year, post and post-holder - from about 2,000 members. As the list of members is a drop-down menu, as you start to type the surname the menu jumps to the first corresponding match, which makes trawling through 2000 members much easier! When the post is added, the form returns the user to the same page to add the next officer.
I would like to have a multiple insert page, where you select the appropriate year at the top of the form and the 20 available posts are displayed in the first column - with a corresponding drop-down list for each potential post holder.
This is where I run into trouble - the multiple insert form appears to be created properly, with all the repeat selections in place - but when I try to test the page, the computer gives up, presumably because it needs to populate drop-down lists for 20 posts with 2000 members.
I wondered if there was a way that I could maybe have the recordset and start typing the surname of the post-holder without the need for a repeated drop-down menu, as this is what appears to be causing the problem. An array of some sort? Don't know!!
I'm using a MySQL database. the appropriate tables are:
years (YrID int, YearName nvarchar e.g. 2010-2011)
posts (PostID int, postname nvarchar)
members (memID int, surname, firstname etc)
postholders (phID int, phYrID int, phPostID int, phMemID int)
Any ideas much appreciated - whilst the single entry method works, a multiple entry page would simplify things for users.
Cheers
Chris
