Adding multiple data in one shot

[Aditya_Vinayak_]

Hello Everyone!

I have the below tables:

1) User
2) Customer
3) Pets
4) Service
5) Payments

Purpose of the app: To add customers & there pet details and schedule appointments based on services required. One pet can avail multiple services.

Suppose if customer is Aditya, and Aditya has 2 pets Oscar & Blacky. So when I add a service, & if both the pets are taking the same service, how can I add it in one shot, rather than adding the service one by one separately.

[dbaum]

There are a few different techniques. One would be to make the Pets column in your Service table an EnumList type so that you can select one or multiple pets.