Curt, You have two tables: Table A is on the left, with "A.Value" referring to what's showing in the list. Table B is on the right, with "B.Value" as the values.
Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like "%;" + 'A.Value' + ";%") Refresh Table A. The "tricky part", if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer "Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky?" - Pink Floyd |------------> | From: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |"Schryver, Curt" <[email protected]> | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | To: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |[email protected] | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Date: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |06/08/2009 12:28 PM | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Subject: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Creating the "two tables with the add/remove buttons in between to swap data between tables" effect | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Sent by: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |"Action Request System discussion list(ARSList)" <[email protected]> | >--------------------------------------------------------------------------------------------------------------------------------------------------| ** Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and "moved" to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax [email protected] _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
