Search results

Thank you very much, but the problem is, within the table I am building, alomst every field has the same problem, e.g. "issues" the book covers may invovle 6 or 7 topics, coutries of publication may be more than one country, so I don't think it is feasible to create so many "sub-tables" Thanks...

Let's say if I am building a database for a library and in a table the book titles are the primary key and there is a field "authors" to record the authors' names. But sometimes a book may have several writers and if I type all of them into one field, Access only recognise as one person. So...