I'm trying to paste data into the last record of a portal row, but it keeps being pasted in the first record/line of the portal. I'm sure it's super simple but I'm stuck.

Here's the setup:

On a layout I have song info, title, length etc. and two portals one for publishers and one for composers that access the contacts table using the Contact ID field as the link. If the data inputter don't remember the ID# for a particular person I have a button that takes him to a search result of all publishers. Once he found the one he wants I have another button that copies the Contact ID and goes back to the previous layout and pasting it into (hopefully) the next empty row.

Copy [select; Contacts::Contact ID]

Go to Layout ["Music Library" (Music Library)]

Go to Portal Row [select; Next]

Paste [select; Publisher List::Contact ID]

I get it to work almost. It keeps pasting into the first row and not the one I clicked in before doing the search etc.

What am I missing to make it paste into the next empty Contact ID in the portal?

Thanks in advance.

Erik Lundmark

When you move to another layout, the cursor is not in a portal. Going to the next row means going to the first row. You could try Go to Portal Row [Last] to get to the bottom row or possibly opening the search result in a new window. It may depend on your setup, but Set Field is the preferred method versus Copy/Paste.

Erik,

You could try somthing like this.

Copy [select; Contacts::Contact ID]

Go to Layout ["Music Library" (Music Library)]

Go to Field [Publisher List::Contact ID]

Go to Portal Row [select; First]

Go to Portal Row [select; Next]

Paste [select; Publisher List::Contact ID]

I know its not pretty but it works. I agree with Queue if you can use set field it is a better method.

Good luck,

Dean