hassam36 0 Posted May 9, 2007 Hello I have 3 tables that I want to display on a form. The tables are related parent -> child -> child where the parent table is behind the form and the child tables are two portals. If I select a certain record in a pop-up menu field from the child table (in portal), how can I get the corresponding value to display in the child portal field next to it? Quote Share this post Link to post Share on other sites
1Adam12 0 Posted May 19, 2007 if what i think you are trying to do is have the content in the right portal change with a selection in the left portal, it's easy. 1st, you need to change your join to the right portal. You need the join to be from a global field that exists in the parent table to the key field in the right portal. then, all you do is have a script that sets the global field to the key field value of whatever record is selected in the left portal and voila, the right portal changes. Quote Share this post Link to post Share on other sites
hassam36 0 Posted June 28, 2007 Thanks Adam. That will work. Quote Share this post Link to post Share on other sites