I am adding data to a file via a portal and after adding it I want to print it out. No matter how I design the TO relationship I can only get it to display the portal row with the lowest portal row ID number. How do I point to a particular row so I can print just the one row??

Use the go to related script step, show matching only, to jump from the parent to the child table (your portal records) and print your child record using a layout based on the child table.

When I try to use the "go to related " it will only show all the records. Can I filter the related records to just the single active record like filtering a record in Microsoft Access? how do I do this. I can find a single record but it seem so circuitous there must be a simpler way? any thoughts?

Your go to related button needs to be on the portal row of the child.

GTRR.fp7.zip

Why don't you simply set your print step to print only current record?

Hi bcooney. I have tried your suggestions but it does not work for me. Each row in the portal has a row ID. I have a layout which is the layout for the printed document. My script is: go to ID, copy, go to layout, select all, go to field (ID field), enter find mode, paste.... then it all unravels. I get a message ID not found. If I use a script it tells me no record found. If I do it manually, it finds the record. What is it doing that I don't know about? The other intensely frustrating thing is if I do a find and I point to a field, it tells the find to look at the [field::name] not the value of the field. How do I get it to look at the value. MSAccess does this so much easier or am I just doing it wrongly?

I have tried this and it still does not work. There are steps which I do not know about which is stopping this happening. What are they?

I don't see your script, so I wouldn't know. To answer your original question (again) to print the record in a specific portal row, place a button in the portal and attach it to a script that does:

Go to Related Record [ ChildTable ; Layout for printing ]

Print [ current record only ]