Thanks a lot for the help. I got that working :) On Wed, May 9, 2012 at 8:09 PM, Shellman, David <[email protected]>wrote:
> ** ** > I've done something similar a couple of times. I have three different > tables on a view form used to manipulate data. Table 2 is a search of data > for the row in Table 1. Table 3 is a search of data in Table 2. > > So my Active Link Guide starts with a table walk of Table 1. A row is > selected. The next Active Link in the Guide does a refresh on Table 2 so > that the data relevant for the selection in Table 1 is displayed. The next > Active Link starts a table walk of Table 2. Next Active Link does a > refresh on Table 3. Active Link pushes the relevant data from Table 3. > Once the Table Walk of Table 3 is complete, Table 2 steps to the next row > ..... This continues until the table walk of Table 2 is complete. Then > Table 1 steps to the next row ... > > The key is the Active Links that fire the table refresh for Table 2 and > Table 3 before starting the table walks for those tables. > > Dave > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Grooms, Frederick W > *Sent:* Wednesday, May 09, 2012 10:10 AM > > *To:* [email protected] > *Subject:* Re: Nested Active Links > > ** > > You have the right idea**** > > ** ** > > A form with a table where you can select multiple employees and a second > table where you can select multiple roles.**** > > ** ** > > On button click call guide 1 that walks the employee table for selected > rows.**** > > In guide 1 an Active Link calls guide 2 that walks the selected roles.**** > > In guide 2 an Active Link that does the push of employee.ID & role.ID to > table 3**** > > ** ** > > Fred**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *sapana motwani > *Sent:* Wednesday, May 09, 2012 8:37 AM > *To:* [email protected] > *Subject:* Re: Nested Active Links**** > > ** ** > > ** Any help would be greatly appreciated. > > Regards, > Sapna**** > > On Fri, May 4, 2012 at 9:55 PM, Sapna Motwani <[email protected]> > wrote:**** > > Hi, > > I have a situation where I have three tables, > > Table 1 Employee Table with two columns Employee Name name and Employee ID > (Primary Key, GUID) (Employee Master Form) > Table 2 Available Roles with two columns Available Roles and Role ID (Role > Master Form) > Table 3 Selected Roles with two columns Selected Roles and Selected Role > ID (Emp-Role Relationship Form) (Emp ID and Role ID integration) > > Now, I have to implement a workflow which can move multiple Available > Roles to Selected Roles table for multiple Employees (Selected Rows of > Employee Master) > > i.e. On click of "Assign Role Button" multiple selected records from > Available Roles table (Role Master Form) should get pushed to Selected > Roles table (Emp-Role Relationship Form) and roles should get assigned to > selected Employees. (Employee Master Form). > > I have created a Active link guide which runs for selected rows of > Available table and push the selected roles to Selected Role table > (Emp-Role relationship form) for one employee at a time. > > Please help/assist to do nesting of active links guides so that multiple > roles can be assigned to multiple employees in one go. > > Any help would be highly appreciated. > > Thanks in anticipation. > > Regards, > Sapna > > ** > ****** > > > ** > ****** > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
