October 15, 200817 yr I have a database with two tables. These tables are related. One of the table layouts has a portal that displays values from a field in the other table. Right now it displays ALL of the values. I would like it to only display the values from FOUND records. How would I go about doing this?
October 15, 200817 yr Portals show related data. Whether a record is "found" or not depends on the table of the current layout, not a related table. "Found" status has no meaning in terms of a portal. I think you want to change the relationship between the two tables to filter out the records you don't want to show in the portal. If you give a fuller description of your tables, fields, relationships, and what you're trying to achieve, you can get a better answer.
November 2, 200817 yr I have a database with two tables. These tables are related. One of the table layouts has a portal that displays values from a field in the other table. Right now it displays ALL of the values. I would like it to only display the values from FOUND records. How would I go about doing this? See http://www.fmforums.com/forum/showtopic.php?tid/197149/
November 6, 200817 yr Add a TimeStamp field to the table containing the found records. Creat another field in the other table (to which to portal is relating) that is global to hold a time stamp. Add the parameter to your original relationship, GlobalTS - TimeStamp. After you perform your find (in a layout not containing the portal), enter a value into the GlobalTS (for example using the SetField(GlobalTS: Get(HostTS) ) script step. and use the replace script step to enter this TS into the TimeStamp for all the found record. Go to the layout with the portal, now showing only the found set. Of course the scripting will use Freeze window to make things look seemless. Good luck.
November 7, 200817 yr I'm afraid that's not going to work at all in a multi-user scenario, where each user can have their own found set. Marking the found set of one user is going to ruin it for everybody else (not to mention that some records may be locked and cannot be marked). This topic has come up several times before, for example: http://fmforums.com/forum/showpost.php?post/278029/
Create an account or sign in to comment