bibliography database - author field question
I have a very basic question (new user) - I am trying to build a bibliographic/reference database and I can't work out how to have an author field that allows you to pick more than one author other than a checkbox which just doesn't work (as hundreds of authors) - is there any way this is possible or do I have to have seperate fields for first, second etc authors? In ms access it is possible to do this by having a seperate table of authors and then forming a relationship that allows one to pick multiple authors from the main table form - is there any equivilant in filemaker?
If seperate fields are necessary for each author is there any way to have a search/display form that will allow people to search all the author fields with the one entry?
thanks for any help
you should use 3 tables. Books, Authors, BookAuthors
BookAuthors will be a join table as books can have many authors, and authors can have many books. All the join table really has to do is store the bookID and the AuthorID. You can use a portal to display the related authors on the book layout.