Andrew, I forgot to mention - Table A and Table B both use the same underlying form for their data. No temporary dataset/form is needed.
Thad On Tue, Sep 20, 2011 at 2:50 PM, Thad Esser <[email protected]> wrote: > Andrew, > > This is actually easier than you think, see below. The key is to reverse > your thinking about how a "LIKE" operator could be used. Read through the > entire setup before focusing too hard on the qualifications. Also, you may > want to add other clauses to your qualfications, such as a check on a status > field. Real life example: : ( 'Status' = "Enabled") AND ( $RequestedList$ > LIKE (( "%;" + 'Request ID') + ";%" )) > > FIELDS: > > Button: Add > Button: Remove > ----- > Temp char field: tmp_SelectedList > ----- > Table A - list of options > Column: col_A_ID > Qualification: NOT(tmp_SelectedList LIKE "%;" + col_A_SelectedID + > ";%") > ----- > Table B - list of selected options > Column: col_B_ID > Qualification: tmp_SelectedList LIKE "%;" + col_B_SelectedID + ";%" > > WORKFLOW > > Active link: Add > Fire on Click of Add button or double click on Table A: > Action 1: set tmp_SelectedList = tmp_SelectedList + ";" + col_A_ID + ";" > (note: this adds the selected record to the list, including delimiters) > Action 2: Call TableRefreshGuide > ----- > Active link: Remove > Fire on Click of Remove button or double click on Table B: > Action 1: set tmp_SelectedList = > REPLACE(tmp_SelectedList,col_B_Selected_ID,"") (note: this removes the > selected record from the list) > ----- > ActiveLink Guide: RefreshTableGuide > ActiveLink (put in guide): RefreshTable > Action 1: set tmp_SelectedList = REPLACE(tmp_SelectedList,";;",";") > (note: this gets rid of double semi-colons) > Action 2: Refresh Table A > Action 3: Refresh table B > Action x: anything else you want done on a table refresh, perhaps updating > count indicators. > ----- > > Hopefully that helps, > > Thad Esser > Remedy Developer > On Tue, Sep 20, 2011 at 1:54 PM, Andrew C Goodall > <[email protected]>wrote: > >> ** >> >> I’m not sure how to put a succinct title on this…I’ll try to explain**** >> >> ** ** >> >> I want 2 tables on a display form with “add” and “remove” buttons where I >> can:**** >> >> ** ** >> >> 1. Add item 1 from Table A to Table B, but then also remove from Table >> A so it does not show up as an available selection again – since user just >> added it. **** >> 2. Remove item 1 from Table B and add back to Table A.**** >> >> ** ** >> >> At the end of the Add / Remove process then I will process that data in >> Table B.**** >> >> ** ** >> >> I can get 90% for what I’m looking for using real forms associated with >> the tables, however in this design the issue I have is that all the original >> available selections are always listed– I do not really want to delete the >> record from Table A only hide it from selection view again.**** >> >> ** ** >> >> So far it looks like I can only associate a table to a form and I’m not >> able to add custom columns to the table outside of that form.**** >> >> ** ** >> >> **** >> >> This is so easy to do in .Net with temp datasets L **** >> >> Currently, I’m thinking the only way I can do this is if I append to an >> External qualification for Table A - where not like items in table B.**** >> >> ** ** >> >> ** ** >> >> Regards,**** >> >> **** >> >> *Andrew Goodall***** >> >> Software Engineer 2 | Development Services | jcpenney . www.jcp.com >> <http://www.jcp.com/> >> **** >> >> ** ** >> >> >> The information transmitted is intended only for the person or entity to >> which it is addressed and >> may contain confidential and/or privileged material. If the reader of this >> message is not the intended >> recipient, you are hereby notified that your access is unauthorized, and >> any review, dissemination, >> distribution or copying of this message including any attachments is >> strictly prohibited. If you are not >> the intended recipient, please contact the sender and delete the material >> from any computer. >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
