Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

How to get the index of the link to another table

931 1
cancel
Showing results for 
Search instead for 
Did you mean: 
wengestionrr
4 - Data Explorer
4 - Data Explorer

Let's say I have a table of Invoices and then a table of payments. Each invoice is an aggregate of payments i.e. one invoice can have multiple payments. How can I get the index of each payment in the list of the invoice?

1 Reply 1
Alexey_Gusev
13 - Mars
13 - Mars

Hi,
a short example
Invoices:

Alexey_Gusev_0-1697753761005.png

Payments (here, in example, first letter is Invoice name)

Alexey_Gusev_1-1697753834423.png

Copying field INV to link field:

Alexey_Gusev_2-1697753886076.png

Created links auto-create back links in other table:

Alexey_Gusev_3-1697753937748.png

Which can be accompanied by lookup field(s)

Alexey_Gusev_4-1697754007850.pngAlexey_Gusev_5-1697754024658.png

 

Alexey_Gusev_6-1697754061545.png

and ROLLUPS:

Alexey_Gusev_8-1697754704760.pngAlexey_Gusev_9-1697754744689.png

I hope this example will help you.