Help me get the service name visible at my payments view!!

[Aditya_K1999]

Hello,
I have the below tables in my app.

1) Customer Database
2) Pet Details --> Linked with customer
3) Service Booking --> Linked with a pet & a customer
4) Service Availed ---> Linked with a Booking
5) Service Details ---> Acts as a database of services, linked with Service Availed
6) Payment Details ---> Linked with Customer & Booking

I have a payments view in my app. I want it to show all the payments collected, along with the booking number, customer detail & the services under the booking. I am able to get all the details except the services under the booking.

Below are the fields in the above mentioned tables:

Service Booking:

Service Details:

Service Availed:

Payment Details:

When I use the formula, [Booking ID].[Related Service Availed] it shows the service ID's & not the names of the service. I want the service names.

[Suvrutt_Gurjar · Accepted solution]

Please try below.

1. In the "Services Availed" table , please add a virtual column called [Service_Actual_Name] with an expression something like [Service Name].[Service Name] 

2. In the "Service Booking" table add a virtual column called say [Services_Availed_Names] with an expression something like [Related Service Availed][Service_Actual_Name]

3. Then in the "Payments Detail" table, the [Service Name] column's expression can be 

[Booking ID].[Services_Availed_Names]