Copy/Paste from One Portal to Another on the Same Layout

[SP Myers]

Okay, this one is seriously bugging me.

I have two portals one for Author/Editor Information and one for sending Advance Copies of particular titles. Both portals are on the same layout.

I'm trying to set it up so that when you enter data into the author name field of the Author/Editor Portal, it will automatically populate the name field of the Advance Copies Portal.

I have it set up for the OnObjectExit script trigger and have used both copy/paste and SetField, but whenever I try to get it to go to an empty portal row, it either still populates the first row of Advance Copies or does nothing. I've tried "Go To Portal Row Last", "Go To Portal Row Next", "Go To Portal Row By Calculation [isEmpty(Advance_Copoes::Name).

Both my supervisor and myself believe that there is a simple solution to this, but neither of us can figure out what it is.

[efen]

It would help to have more information on the structure/ relationships of the tables in your file

[SP Myers]

I can try...

Basically there is one main table: wvup_database.

After which, there are a number of sub tables: author_information, advance_copy, footer_information, etc.

Each of the sub tables are related to the main table using a field, that is set up to have a serial value.

[efen]

Sorry for the delay in responding - is the attached any help? Author name not automatically transferred though ... [no script triggers in version 8.5]

AuthorAdvance.zip

Edited August 2, 2009 by Guest