Look at the source code of this app: http://www.web2py.com/appliances/default/show/63
It does what you ask (although for radio logs but you can change table names and add fields) and it is very compact. Done by the book. On Oct 18, 12:59 am, Markandeya <mrc55...@gmail.com> wrote: > Dear Friends of Web2py, > i am starting out with Web2py and Web Apps. I have a Parent Table of > Service Calls and a child table of Visits. When making an edit form > with both tables visible, one below the other, I need to be able to > click on a Parent (Service Calls) table cell or row and have the > child (visits) table then filter or lookup the records for that Parent > Service Call Record. Then when a child record is edited or added it > needs to be shown in the child html table. This is a usual and > recurring situation in many webapps or pages. What is the best > practices way to do this? Bring in all 50-100 child records in a > dictionary or array and then have a function that displays them in the > Child Html table? or go to the database each time? And what event on > the page or in the html table can be used to show when a Cell or Row > is clicked by the user? Also if my Parent table has a field for number > of calls, then with each added or deleted call record the parent db > and html table also has to be changed. How best to accomplish this. > Maybe there is tutorial or example or simple web2py program/webapp > that might help. > Thanks for putting up with beginners ignorance. Any guidance will be > welcome, Thanks Markandeya