I am developing a database for media contacts in my office. Right now I have two relational databases -- one for the reporters and another for where they work. I have made a third relational database called Activity History -- through this database, I would like each reporter to have a running history of the press releases, "the activity," we send out to them. Right now I have a portal set up from the contacts database into the activity history database and when they click on "New Activity" -- it takes them to a new record in that database to enter in the press release information and then the script copies the Activity ID and pastes into the Activity ID field in the first record of the found set in the Contacts Database and then replaces all records in the found set (since many reporters get the same press release) with the same Activity ID so that all the reporters who get that press release now have a record of this.
My problem is that right now I have in the script "Go to Portal Row (Select, Last)" but despite this, whenever the "New Activity" script is run it overwrites the first one in the list; so I can never get past one record in the "Activity History".
Any ideas? If there is a better way to track this kind of information, I am open to that too. My thought was that this would be a many (reporters) to one (one press release) relationship between the Reporters database and the Activity History database.