What? instead of repeating field

[TDebb8594]

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?

[Vaughan]

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.

[TDebb8594]

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?