I have 3 tables:
author
paper
author_paper
I need for a user to be able to enter his paper into the system along with his co authors. So I will need an author table to contain all authors and a paper table to contain all papers and then link the two with the author_paper table. I can do this in access I just can not get it to work here. I am not sure if I use a database join element or use the join in the list area?
The main problem is that there can be only one author per table and only one paper per table, but there can be many authors and many papers in the author_paper list.
author
paper
author_paper
I need for a user to be able to enter his paper into the system along with his co authors. So I will need an author table to contain all authors and a paper table to contain all papers and then link the two with the author_paper table. I can do this in access I just can not get it to work here. I am not sure if I use a database join element or use the join in the list area?
The main problem is that there can be only one author per table and only one paper per table, but there can be many authors and many papers in the author_paper list.