mattr

It works! Thankyou for the tip! For anyone else using this, you will not be able to use a "Go To Related" script after executing the New Window script because you lose the relationship link to the portal you are working in. Instead, I had to go the child database and execute a find script for the related record. Works great. Thanks again!

Let me clarify. I have three tables: Customer; Customer Items; and Items for Sale. I have a portal displaying a list of Items for Sale for a customer. I want the user to be able to scroll down the items and toggle a portal row ON/OFF. When toggled ON, the row is highlighted so the customer knows he/she has selected that item. The customer can then continue scrolling down the portal and select other items, toggling them ON/OFF as desired. Envision a portal with 20 rows. My problem occurs when the customer selects an item that is say portal row 50 on a 20 line portal. If the customer scrolls down the list to portal row 50 and selects the toggle button, the record immediatley moves to the bottom row of the portal. This happens because I am exiting the portal and executing a script in another table and then returning to the portal. The toggle is a radio button scripted to perform the following: 1) set a global to Get(PortalRowNumber) to remember the portal row 2) Exit the portal and create a new record in the Customer Items table. 3) Set a couple of fields in the Items for Sale table so that that selected line items will show up as highlighted on the portal. 4) Return to the Items for Sale portal shown in the Customer table 5) Return to the correct portal row in Items for Sale. When the user selected the toggle button, they may have been mid-way down in the portal. After the script is performed, the item now shows up at the bottom of the portal. Note that if they select an item that shows up within the first 20 records of the portal, the script will return to the user to the correct position on the portal and will appear fine. I found an earlier thread that solved this problem in FM5 (See "Fixed Portal" http://www.fmfiles.com/tnt5.html). I have not attempted this yet on FM8. I have been using FM5 for several years and just recently upgraded from to FM8. Wow! FM8 is great! I'm still getting to know the product and hoping there a better way in handle the "fixed portal" in FM8. Thank you for any help you can offer.

Is there a way to freeze the portal so you can exit, do a script, and then return the same spot you were in previously? I have scripted it so that I can leave the portal and then return to the previously selected record, but the record always shows up at the bottom of the list and the user has to reorient themselves to the data. Is there a better way?

Check out the "Contacts Management" template that comes with FM8. The third tab on the main entry form shows a good example of portal filtering. The tab allows you to select filtering by "Company", "Name", and something else. I imagine you could make a value list of "tasks" for your filter. Good luck!

Thank you for responding! You're right, i could print P_attach from P_line_items, but I would end up with LineItem1, Attachment1, LineItem2, Attachment2,... I would prefer to have the lineitems grouped in a table at the beginning of the proposal, followed by the attachments. The attachement may be many to one, by the way. I'm thinking now that I may need to have a separate child database for printing that stores reference to each line-item and attachement. Then I could print in any order I want. ... need to think on it some more. I will let you know if I have a breakthrough!

Hi all! How do I print a proposal having multiple line-items and multiple attachments? The line-items and attachments are in separate child databases (P_Line_Items.fp5 and P_Attach.fp5, respectively). The attachments are all 1-page container fields and require page-breaks between each one. By printing from the P_Line_Items database I can get the proposal line-item table and body to slide/print nicely. How do I get the 1-page attachments (container fields) to print after the line-items? In the past, I have printed in separate print sessions... not nice for faxing or emailing!