Ref is not working

[Aditya_Vinayak_]

I have the following tables:

1) Customer
2) Call Log
3) Service
4) Payments: Fields: Payment ID (Key), Service ID (Ref), Customer ID (Ref to Customer Database), Amt. Paid (Price), Customer Name V (Virtual Column - [Customer ID].[Customer Name]) etc

Issue is that even after using a ref, in the back end database suddenly the customer ID has stopped showing up because if which for each customer I am not able to see the related payments.

I tried everything, but I am not able to understand the reason.

Can someone please guide.

[Aurelien · Accepted solution]

Hi @Aditya_Vinayak_ 

How do you proceed to create a new payment record in the app? To me, it looks like you don't select the customer, hence the field remains empty.

[Aditya_Vinayak_]

So i will try to explain the best way possible:

1) Create a customer
2) Create a service under that customer
3) Create a payment for that particular service

Under payments Customer V is a virtual column which through the above formula should take the customers name automatically right?

[Aurelien]

---

@Aditya_Vinayak_ wrote:

Under payments Customer V is a virtual column which through the above formula should take the customers name automatically right?

---

Yes, provided the customer is selected first.

This: 

Will automatically select the customer, because you are on the Customer detailed view.

[Aditya_Vinayak_]

Yes...but i am not able to understand why its not working....

[Aurelien]

Did you check the option "is a part of" for your child table?

[Aditya_Vinayak_]

No i didnt