Skip to content
View in the app

A better way to browse. Learn more.

Learn more

Just a simple database - is it that difficult?

Featured Replies

  • Newbies

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

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/

Create an account or sign in to comment

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.