I have 3 tables:
- Customer Details
- Pet Details (Which is under Customer details)
- Service Details (Which is also under customer details)
Basically, when I add service, I want an option to choose from, for which pet is the service?
Pet 1 or Pet 2 & then accordingly it should proceed?
Is there any way to do it?