AnsweredAssumed Answered

Entering and viewing multiple values

Question asked by Ariel on Oct 29, 2008
Latest reply on Oct 29, 2008 by scottgh

Title

Entering and viewing multiple values

Post

Hi, I am working with an existing library database, where one book can have multiple authors, subjects, library locations, etc.

 

So for example, to relate books and authors, my database includes the following tables:

 

Book

-Book ID

-Title

-ISBN

 

Author

-Author ID

-Last Name

-First Name

 

Book_Author

-Author ID

-Book ID

 

My goal is for all these fields - Book Title, ISBN, author(s), subject(s) - to look like a single seamless "record" per book to the end user. So, within a single book "record," we need the ability to view multiple authors per book, as well as the ability to enter multiple authors when creating new book records.

 

Ideally, all values entered would be validated against value lists (e.g., the Author list or the Subject list), and new values (e.g., new Authors) could easily be added.

 

I’m new to FileMaker, so any advice would be greatly appreciated!

Outcomes