DBMan can handle the many-to-many relationship. There should be three tables Category, Author, Category_Author

Category
--------
cat_id (PK)
cat_name

Author
------
auth_id (PK)
auth_name

Category_Author
----------------
cat_id (PK)
auth_id (PK)

Now create the Category - Category_Author and Author - Category_Author relationships.

You can have a look at relationships in our bookstore demo ( Book - OrderDetails and Order - OrderDetails) as an example.

TheStone.

B.