Intermediate Table

[Parisi]

I have the following scenario:


tblBooks - fields: BookID, BookTitle, BookDate
Example data for tblBooks:
1, Harry Potter, 1/1/1990
2, Sewing for Dummies, 2/2/1995
3, Needlework, 7/2/1999

tblAuthors - fields: AuthorID, AuthorName
Example data for tblAuthors
1, JK Rowling
2, Bob Smith

tblBookAuthors ? fields AuthorID, BookID
Example data for tblBookAuthors
1, 1
2, 2,
3, 2

I have a Fabrick list that of tblBooks and I want to be able to add authors to each book. So a user enters a new book and I want them to be able to add the author to the book from the existing list of authors or create a new author as needed. Each book can have more than one author.

Help - how do I do this.

Thanks,
Paul.

 

[troester]

This is a many-to-many relation.
Your setup is ok but your tblBooksAuthors needs an additional id element.

http://fabrikar.com/help/tutorials/details/3/22
This is an old Fabrik2 tutorial but still showing the principle (tables are lists now).

 

[Parisi]

ok - so I watched the video about 6 time and I finally have it working ! Woohoo. Thanks so much for your help!

I do have an additional question - I have my Authors in the List view but they seem to have a bullet in front of them and a line below them, see the screen shot. Any ideas why it would add both of those? I can understand the line if there was more than one author but not the bullet.

Thanks,
Paul.

 

[cheesegrits]

Looks like a CSS issue. if you can point me at the page, I'll take a look.

-- hugh

 

[Parisi]

Hugh,

Thanks, can you register for an account? I will authorize it and then you can see it.

Paul.

 

[Parisi]

I now see that I need to give the website http://beza.savior<remove>labs.com

Alternatively you can use the site info in my profile.

 

[cheesegrits]

Looks like you have some kind of htaccess issue, I'm seeing a "Failed to load resource: the server responded with a status of 403 (Forbidden)" for the template_css.php in the list's bootstrap template folder. So the CSS isn't loading.

-- hugh