The title says most of it but here are the details:
Table 1- I have table of customers each with there own equipment listings.
Table 2 - I have a second table where I can log corrective action items for customers and their equipment
I have Table 2 set up so it references back to Table 1 for the full list of equipment (all equipment in the list regardless of customer).
I wan to be able to filter the equipment list on table 2 based on the customer that I pick. only showing the equipment for that customer.
How do I do this in APPSHEET? I know 100 ways to do it in excel/googlesheets, but it’s not helping me here.