I am trying to make an app for my brothers service business. This is the setup:
A Customer has a few Plant Rooms which has a few Machines
I have this bit set up and i can click into a customer and then into a plant room and see that customers machines.
Now I want to create a record if the machine is serviced. I set it up so you can look at services and click “+” to add a new service. You select the customer + the plant room + the machine and then fill in the details of the service.
My question is this - Can i create dynamic dropdowns so as the service record is created the choices of plant room / machine relate to only that customer? Or can i click thorough into a machine (via customer > plant room) and add a service record and have that machine auto-populated into the input via hidden value?
Thanks for the help!