Journal published dates script help

[carol333]

hi

I am only a basic level filemaker user so I am not very good at scripting. I have a database of about 200 journals all published varying numbers of issues per year - Each issue has its own record with dates for each stage of production.

I need to create a layout which shows me the date the last issue of any particular journal was published and the date the next issue is due (each issue record has fields for these dates) but my problem is how to make a script which shows ONLY the dates for the last one published and the next one due - ie I can't work out how to do it without including every issue published in a year - some have 12 issues a year.

I would be grateful for any help

with thanks

Carol