Just a simple database - is it that difficult?

[UserFriendly]

I must admit I'm somewhat new to databases, no experience so far. I was assigned to develop a simple database with Filemaker, but after hours of scrutinizing the starter-examples and the web for tutorials I don't see a solution.

What I want to create is a simple database with 2 Tables: Books and Articles.

Books contain multiple articles, but sometimes the same article can occur in different books.

So in the formular view of the books I want to see next to the book data (author, title, etc...) also a list of the articles which are contained in the book (which is done via Portals?)

In the formular view of the articles I want to see also in which books a certain article is contained. Also the list should be modifiable in order to add more articles to a book and the other way round.

I found some kind of an example in the starter-example of Eventmanagement (The relation between contacts and events), but I didn't get so far to understand the system.

Is there a simple method to do this or a tutorial or a simple sample file I could download.

I would be utterly thankful for help.

Sorry in advance for language mistakes

[comment]

Books contain multiple articles, but sometimes the same article can occur in different books.

IOW, you have a many-to-many relationship between books and articles - and you need a third table to join the two. See a basic example of a join table here:

http://www.fmforums.com/forum/showpost.php?post/246136/