Re: How to deal with identical fields in db

PJ wrote:

I'm coming up with a bit of a quandry: how to enter and retrieve an identical book title with different authors. It is rather unbelievable what contortions one finds as authors :-( like editors, associations and then the unknowns and anon y mouses. I suppose one has to get really creative... Anyone for tea? You should have a title_id field in your titles table, and this field should be unique. Probably auto assigned and auto increment.

If you search for a book title, and there are two books with that title, you should get two records back! Stephen