V. Large Select Box?

[NickyM999]

HI there all,

I was wondering how to do the following:-

I have a books database which has tables of book and authors (amongst many others) and I want to create a book entry page. Problem is if I make a select box for authors and build options from the authors table, I am left with 500 choices of author!! Also I have the problem that I may need to create an author if it does not exist in the authors table. Can anyone suggest a neat way of doing this? The books table has fields for authorids (i have several fields as sometimes more than one author per book!) I am trying to make the book entry fit on one page.

TIA

Nick
[e-mail]

[daveyboy]

A-Z anchors and links along the top? Or maybe you'll have to go for a page per letter.

[Ace_Online]

I would suggest that you use the anchors on a long page and have each author's name be a link to the current page you are posting the form to with ?author=$Author_Name on the end of the link. That would probably be the most logical solution. You could then just include a text box if they want a new author.