My situation is like that of a many to many relationship with authors to books. There can be many authors for one book and an author can write many books.
I understand how to make the relationship in fabrik and it works great; however in my case I would like registered users to create all the data. So a user would login and would type in the name of the book on a form and then would type in the authors. This obviously does not work because the database join is a drop down and seeing there are no authors in the database it does not work.
One way I found around this is by adding the add button to the database join element where it popups a form to add an author and this is fine; however when I click save on the popup form the form does not go away and seems like nothing happens, even though it does save the record to the database. A user though may become confused by this. Another issue with the popup form is once it is saved the option is not in the database join element drop down, until I refresh the page. It would be ideal to populate the database join drop down with the saved record.
So any advice on how I can make this easier for a user would be great. The main thing I need done is for a user to enter in a book and then add authors to the book. I expect to have about 800 books and 2000 authors.
Thanks in advance
I understand how to make the relationship in fabrik and it works great; however in my case I would like registered users to create all the data. So a user would login and would type in the name of the book on a form and then would type in the authors. This obviously does not work because the database join is a drop down and seeing there are no authors in the database it does not work.
One way I found around this is by adding the add button to the database join element where it popups a form to add an author and this is fine; however when I click save on the popup form the form does not go away and seems like nothing happens, even though it does save the record to the database. A user though may become confused by this. Another issue with the popup form is once it is saved the option is not in the database join element drop down, until I refresh the page. It would be ideal to populate the database join drop down with the saved record.
So any advice on how I can make this easier for a user would be great. The main thing I need done is for a user to enter in a book and then add authors to the book. I expect to have about 800 books and 2000 authors.
Thanks in advance