Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Create an line number based on The Invoice Number

Topic Labels: Automations
506 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