Table references

I have 3 tables:

1) Customer Details
2) Pet Details (Which is under Customer details)
3) 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?

0 2 69
2 REPLIES 2

Top Labels in this Space