Dashboard nesting Tables

This topic is locked

Dashboard nesting Tables	9/21/2015 11:37:23 PM
PHPRunner General questions
ladykathleen author I have created a Dashboard and have been able to nest the tables as such Table 1 ->> Table 2 -->> Table 3 --->> Table 4 & 5 This all works great as long as the person entering data enter each table in order and has at least one record for each table. that only problem I have is when one of the records is not finished in the set. so say in one record you are missing the Data or there is no information yet for Table 3 and Table 4 & 5 when you view this record Table 3 will say NO RECORD but Table 4 & 5 will display the data from the previous viewed record before instead of displaying NO RECORD. What I would like to know is there some kind of code I can add into the events section that will clear all tables before loading the correct information. and if there is no corresponding data in a certain table it will display No Record


	ladykathleen author 9/24/2015
	Adding more information in case the first post is not understandable enough. I would like to know what I can add to OnClick on the Dashboard where it would clear all old information before displaying the current line items. Something like clearing all boxes Child and sub Child boxes before displaying a new master record The Dashboard already will clear the First Child Record in this situation Master table >.> Child But on a Master Table >>Child >> Sub Child it will not clear the sub Child when the master Table is changed and there is no record in the Child and Sub Child. The Child will Clear and say No Record Found but the Sub Child will still display the old information. Example: of 2 records Table 1 Mary John Table 2 (this one only has one record for Mary) North Office (Child record of Mary) Table 3 (this one only has one record for Mary) Bookkeeper If I use the dashboard I am on Mary's Record It will display Mary >>North Office >> Bookkeeper If I click on John's Record it will display John >> No Record Found >> Bookkeeper On the John's Record is should display John >> No Record Found >> No Record Found