Hello all, I need to model a many to many bidirectional relationship.

octavianp over 8 years ago

Hello all,

I need to model a many to many bidirectional relationship...which I know that is not available in Appian, but I am trying in some other ways.
The scenario is the following I have an application object which have two lists: list A and list B. In the interface I receive the application object through a rule input, and I have three sections:
- One editable grid for list A. This controls ri!application.A_list
- One editable grid for list B. This controls ri!application.B_list
- One editable grid for the link between them (this is basically a reproduction of the clasical many to many lookup table), which contains 2 dropdown fields, one for A one for B. This controls ri!application.A_B_list.

My initial ideea was to save in the A_B Link CDT the IDs of the entities A and B which are corelated. But this can not be applicable (or at least I was not able to do it), because at the moment of the creation, A and B entities do not have IDs. We need to...

Discussion posts and replies are publicly visible

Parents

0 mpontius over 8 years ago

You could use two screens with a write to the DB inbetween them. Have your user input task with Grid A and Grid B on the first screen, have the save to DB node, then another user input task for the linking of the two Grids.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mpontius over 8 years ago

You could use two screens with a write to the DB inbetween them. Have your user input task with Grid A and Grid B on the first screen, have the save to DB node, then another user input task for the linking of the two Grids.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data