Get Row details from other table in db
Get Row details from other table in db
Andreo
Posts: 2Questions: 1Answers: 0
New to the forums, sorry if this is in the wrong section!
Curious how I would get the value of a row details that is located on another table in my database. What I am trying here is to show the parent row details from my main table in my db then the corresponding details will be in another table, so when a new info will be submitted to my db, a new row details will be shown after the previous details.
Any ideas?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Conceptually, you can left join your two tables parent on child. When returning the data from the database, put the all into into a json array (nest it), but do not set up for table display. Set up the table to use children rows, then when expanding a child, show the children data.
i see, i got your point glenderson! thanks for sharing your ideas..