If I understand, your setup will not work. It is trying to link common columns between the tables in the two grids, and because your color column is called the same (I'm guessing) it will only show the match, which is probably the exact same data as on the left.
To do that, you'd have to make sure the 2nd grid is based on a table/view that has only ONE linking column to the 1st grid. Like if on the left you had: AcctNo INT ColorCol TEXT 12 You button would have to create a temp view (or a temp table): create temp view vTest (AcctNo, ColorCol2) as select acctno, colorcol from <tablename> property table vTest 'refresh' That way AcctNo is the only link. Karen -----Original Message----- From: Carpet Broker, Dick Fey <[email protected]> To: RBase Maillist <[email protected]> Sent: Fri, Sep 1, 2017 12:12 pm Subject: [RBASE-L] - Form problem Building a form with 2 db grids. Left grid displays all products that contain a certain color name or number. Upon clicking the desired style with a on click eep, I want to display all the colors in the selected style in grid 2. I project a temp table containing all the colors. If you look at the table it works perfectly, but the dbgrid on the right only displays 1 line. Its like you display a list of products on the left, clicking the field displays a list of necessary parts on the right. So close, but no cigar. ??? Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
