Hi,
I have two tables with name x and y,
X has 20 columns with name of text1,text2,text3.. text20, and additional some columns as id and cif - which is used to store the values in this one row isequal to one line which includes all 20 cols
y has 20 columns with name of text1,text2,text3.. text20, and additional some columns as id and cif - which is reference for x table
using both the table i have show the values of x table all 20 cols of one row in one line
how can i achieve this?
as of now i used only X table to show the values and just concatenated all the cols
is this right way to do?
Thanks
Kavya Muttur
Discussion posts and replies are publicly visible
A common pattern is to have two components in your user interface, one to show the list of rows in table X (lets' call this the 'Summary' view) and another table that shows the content of table Y only for a selected row in table X (let's call this the 'Detail' view). Unless there's a specific reason to see all of the data in one go (which is somewhat overwhelming to a user) then this is a better pattern to use.