Help

Create an line number based on The Invoice Number

Topic Labels: Automations
210 0
cancel
Showing results for 
Search instead for 
Did you mean: 
jb
4 - Data Explorer
4 - Data Explorer

I have a master table Invoice with a fiels Invoice_Number and a detail table Lines.
Each Line belongs to a single Invoice.
In the table Lines I want to setup a field Line_Number and I want to automatically populate its value.
Line_Number must simply contain the line number of its Invoice.

For example : Invoice A has 3 lines numbered 1, 2, 3 and Invoice B has 2 lines numbered 1 and 2.

Does someone knows how to setup this field ?.
Thanks by advance.

0 Replies 0