I have a simple database of publications. These publicaitons have from 1 to 6 authors.

I need to be able to search by author, which works with a repeating field. I also need to be able to run a report showing all authors of each publication.

How do I make this work?

You need a related table to hold the authors. Use a portal to display them on the publications layout. Print using a list layout in the authors file, don;t print layouts.

The "Go to Related Record" script step is useful for working with sets of related records.

Thanks for the idea, but I'm not sure how to make that work.

When I enter a new records one of the fields to be filled is "Authors". Are you saying I first have to enter the Authors name in a seperate DB then also enter it in the publications DB?