Self-Joined- Repeated Info.????

[Yasmeen06]

Hello Everyone,

Im so very lost. I read the books, I've asked FileMaker but I can not figure this out.

I created a database for our writers in our publication.

I have to list the following for each writer:

Article Name |_______________|

Issue Contributed |_______________|

Payment Amount |_______________|

Note: Issue Contributed is a drop down menu

A writer may have written in 1 , 2, 6 , etc issues.

Here are the questions,

1. How can I add another section in each writers account when needed to add the above information?

2. How can I create a list that will show what each writer has written?

3. How can I create a search based solely on Issue number?- i.e list all writers who have written in Issue 5.

Thanks for you help

Yasmeen

[Yasmeen06]

I figured it out.