I have a series of tables that get populated based on the entry of an single email. The value of the email input is used in a series of Queries, both JS and Firebase/Firestore tables. There are various parent/child relationships where rows are found, or not found, and the results populate the tables.
- As soon as I start the search I want to clear the data from all the tables as it is no longer valid.
- In fact if there are no records returned for a given query based on the new email, the table rows from the last query (a different email) remain.