StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>Solution 1</strong> </p> <p>If the data sets are not too big, use a table and allow users to place checks in cells (table 1 is X axis and table3 is Y axis). </p> <p>You can probably do this for larger table1/3 data sets as long as you allow users to filter or otherwise limit which values are displayed on x and y axis.</p> <p><strong>Solution 2</strong> </p> <p>To quote from <a href="http://www.databasedev.co.uk/many_to_many_example.html" rel="nofollow noreferrer">this page</a>, "A many-to-many relationship is really two one-to-many relationships with a junction/link table".</p> <p>As such, you can, as one solution, simply take your own solution and resolve your first 2 dis-advantages by having screens/dialogs to go table 1=>3 as well as 3=>1.</p> <p>Not a perfect solution but at least provides all the needed functionality</p> <p><strong>Solution 3</strong> </p> <p>Somewhat similar to your own solution:</p> <ol> <li><p>Show a table based on table1, with:</p> <p>B. col1 containing table1 elements</p> <p>C. col2 containing a list of all elements from table3 already associated with this element from table1. </p> <p>The list can be either horizontal if there are usually few elements associated, or vertical (scrollable) if horizontal to too wide.</p> <p>The important part is that every displayed element from table3 has a "delete" icon (x) next to it to allow removal quickly.</p></li> <li><p>Allow choosing which element from table1 you want to add mappings to.</p> <p>There are 2 ways of doing this - either add a checkbox to every row in your table, and have one button labeled "add relationships to selected rows" (wording needs improvement), or simply have a 3-rd column in the table, containing button/link for adding relationships to that individual row. </p> <p>The former is a good idea if the user is likely to often add exactly the same set of element from table3 to several rows from table1.</p></li> <li><p>When "Add" button/link is clicked, you display a filterable multi-select list of elements from table3, with "add selected" button.</p></li> <li><p>As in your solution (see my #2), this is a-symmetrical so you should implement a mirror UI for mapping from table3 to table1 if needed.</p></li> </ol>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload