Printing portal row

[Confused3]

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??

[bcooney]

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.

[Confused3]

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?

[bcooney]

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

GTRR.fp7.zip

[comment]

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

[Confused3]

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?

[Confused3]

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?

[comment]

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 ]