i am creating a newsletter db to go one the web there will be three issues a year for 30 different countries which i want to keep in the db for people in the office to browse. but i only want the newest one for each country on the web

can any one think of a way to self relate the same countries and calculate by issue number the newest record

Don't use portal.

Sort on Issue Number (decreasing) than present countryRel::NewsLetter

or use last(countryRel::NewsLetter)

Dj

cheers for that

i had found a way just before you sent that

i used a rel on country and set a field to = max(country rel::issue num) and the set another calc to if(max = issue num ; "newest"; "old")

which works fine

cheers