Ok i have the following two tables.

Member(Name,Country,Points,Ranking,Season ID)

Seasons(Name,Comment,Season ID)

I have also created a self link from season to season based on Season ID,using a second occurence/copy of the season table(Seasonscopy).I changed the relationship from '=' to 'x'(ie match all records.)

It is season 1 currently so i have assigned members to season 1 then created a portal to show related records from member.

When a certain date arrives, i will start season 2. When i do this i want all the points in member layout to reset to 0 and the season field to change to season 2 for everyone.

A new record will then be created on the portal layout and the points for season 2 will be displayed.

However on the first record i want the portal to be archived so i will be able to see what points people got in season 1,even if the member layout fields changed.

What would be the best way to do this.

Edited May 27, 200619 yr by Guest

I'd guess your native language is Spanish. Please if so, ask your question in this language in order for me to understand better.

Best Regards,

Hi riley, and welcome to the Forum.

Sorry, this is a English list, and we asked that the questions and responses be in English. You can translate the questions, and your replies in a site like

http://babelfish.altavista.com/

HTH

Lee