fbugeja Posted February 26, 2005 Share Posted February 26, 2005 I am a teacher in the process of creating a database for staff use. The database contains a number of portals. In one portal, I have included a print button which shows in every portal row. I had hoped that the print button would use the field data in that portal row and use it in a letter to be printed out. Alas, it is not working as it appears that only data from the first portal row is being used. Simply, how do I ensure that, if I click the print button in the 4th portal row, the field data in that row gets used in the letter, and not the field data in the first portal row? Many thanks! Frank Link to comment Share on other sites More sharing options...
bruceR Posted February 26, 2005 Share Posted February 26, 2005 You are going to need to provide a lot more information about what you are doing. Link to comment Share on other sites More sharing options...
fbugeja Posted February 26, 2005 Author Share Posted February 26, 2005 The portal has a number of fields. I would like the contents of those fields to be included in a letter. By including a print button in each portal row, I was hoping to use the field data in that portal row in a letter that would be printed after I click the print button connected to that portal row. At the moment, regardless of what portal row print button I click, only the field contents of the first portal row are used - not what I want (unless I want to print from that row). Hope this helps. This is the print script attached to the portal row buttons If [ IsEmpty ( Zero Award::Date ) ] Show Custom Dialog [ Title: "Reminder"; Message: "There are no details for a Zero Award Letter to be printed out"; Buttons: "OK" ] Exit Script End If New Window [ Name: "LetterZeroAward"; Height: 800; Width: 675 ] Go to Related Record [ From table: "Zero Award"; Using layout: "Zero_AT0N Letter" (Zero Award) ] [ Show only related records ] Perform Script [ "PreviewPrint" ] Close Window [ Current Window ] Adjust Window [ Maximize ] Enter Browse Mode This is the PreviewPrint script Allow User Abort [ Off ] Set Error Capture [ On ] Print Setup [ Orientation: Portrait; Paper size: 8.26" x 11.69" ] [ Restore; No dialog ] Enter Preview Mode [ Pause ] Print [ ] Enter Browse Mode Frank Link to comment Share on other sites More sharing options...
transpower Posted February 26, 2005 Share Posted February 26, 2005 Make sure that the GTRR step is based on the same relationship as that on which the portal is based. Link to comment Share on other sites More sharing options...
bruceR Posted February 28, 2005 Share Posted February 28, 2005 Your new window step is the problem. You've lost focus on the portal row at that point. Instead, you should be using the the GTRR with show in new window turned on. Link to comment Share on other sites More sharing options...
fbugeja Posted March 1, 2005 Author Share Posted March 1, 2005 Thanks to all who helped with my query. What I did was to put New Window line after the GTRR line (as recommended by BruceR - and it worked! Thanks from DownUnder! Frank Link to comment Share on other sites More sharing options...
fbugeja Posted March 1, 2005 Author Share Posted March 1, 2005 Sorry - my previous posting was incorrect! I misread BruceR's previous answer! I went again and did what BruceR specifically said - and it worked! Thanks BruceR (and transpower). Frank Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6995 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now