This is how I have approached this problem in the past: I do a single join form:
I do an outer join between table a and table b where a.instance id = b.instance id In the first table I only display records where b.instance id is null In the second table I only display records where b.instance id is not null. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Wednesday, September 21, 2011 10:09 AM To: [email protected] Subject: Re: can I have a table field with a temp dataset? ** Andrew, If you make your table for Table A be a join of A and B, and make the join do something like 'A GUID != B.GUID' or something like that, then A would automatically filter based on the contents of B as well. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Andrew C Goodall Sent: Tuesday, September 20, 2011 2:54 PM To: [email protected] Subject: can I have a table field with a temp dataset? ** 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 :( 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"_ _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"
