Help

How to get the index of the link to another table

519 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

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.