I have a many to many relationship between authors and papers(author table, paper table, author_paper table). The join is setup and works I guess I just do not understand the best way for the users to enter in the data.
I have a database join element of a drop down. First there could be over a hundred authors in here so going through the drop down is not a good idea. Then there is the search option which is great though if the author is not in there, there is not an add button on the search form. The user has to close the form and hit the add button. If an add button was on the form that would be great.
How do others handle this issue with a many to many table?
I have a database join element of a drop down. First there could be over a hundred authors in here so going through the drop down is not a good idea. Then there is the search option which is great though if the author is not in there, there is not an add button on the search form. The user has to close the form and hit the add button. If an add button was on the form that would be great.
How do others handle this issue with a many to many table?