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
