Im trying to build a database to organize comics.

I want to track the Appearance of other characters.

So.

One comic can have many different Guest Appearences. Thats a 1 to many.

A character can be a guest in many comics. That is also a 1 to many.

So I have a many 2 many relationship. That is not good.

What can I do to break this up? Create 2 tables. One to track the guest appearances and another to act as a lookup and track characters?

Im very confused.