AnsweredAssumed Answered

Citing a source for every field

Question asked by MichaelLyons on Nov 15, 2014
Latest reply on Nov 18, 2014 by WBSimon

Title

Citing a source for every field

Post

Hi,

I am trying to develop a database that includes the option to cite a source (book, journal, etc.) for every single field in multiple tables.  Some tables would have 50+ fields.  Each citation should have the author, title, year and page number.  The way I am considering doing this is to create a new table for sources and creating many to many relationships between the sources table and all other tables.  The sources table would hold the author, title and year (and any other relevant information about the source), and a page number field would have to be created for every single field on their respective tables.  Would it make sense to make a separate table just for page numbers and create another many to many relationship?

Does anybody have any experience with this type of set-up or any ideas how to make it more efficient?  The only part I am concerned about is having to create a page number field for every other field.

Thanks!

Outcomes