aagghh how to link a Cell to a Table?
aagghh how to link a Cell to a Table?
Visualize two DataTables.
Table 1 has two columns, ID and ITEMS
Table 2 has two columns, ITEMS and DESCRIPTION
The ITEMS row in both tables are the same, except that in Table 1 there are many items seperated by ; symbols.
When you click a ITEM in Table 1, I need Table 2 to filter only matching items of that within Table 1's ITEM cell.
The end result would have this Before and After I made in Excel:
You can see I selected an item on Table 1 and that's why Table 2 is filtered to those items.
http://img687.imageshack.us/img687/4007/ebd5774b7e804d8f83b2a24.png
Even if this can be accomplished easily by merging the tables somehow, I need to know how to do this without merging the tables because the actual project I'm working on has extremely long descriptions for each item!
If you solve this you're my God!!!
Table 1 has two columns, ID and ITEMS
Table 2 has two columns, ITEMS and DESCRIPTION
The ITEMS row in both tables are the same, except that in Table 1 there are many items seperated by ; symbols.
When you click a ITEM in Table 1, I need Table 2 to filter only matching items of that within Table 1's ITEM cell.
The end result would have this Before and After I made in Excel:
You can see I selected an item on Table 1 and that's why Table 2 is filtered to those items.
http://img687.imageshack.us/img687/4007/ebd5774b7e804d8f83b2a24.png
Even if this can be accomplished easily by merging the tables somehow, I need to know how to do this without merging the tables because the actual project I'm working on has extremely long descriptions for each item!
If you solve this you're my God!!!
This discussion has been closed.
Replies
Allan