AnsweredAssumed Answered

Auto-enter the record number?

Question asked by stuart91 on Sep 26, 2017
Latest reply on Oct 16, 2017 by stuart91

I've been surprised by how difficult this is - not sure if I've been missing something obvious.

 

The database I'm working on has a table for orders, and a related table for the line items on each order. The users set up a new order, enter the details, then add line items via a portal.

 

What I'm hoping to do is auto-enter the number of "line item" records per order. So when the first line item is created, "1" will be entered into the field, then "2" for the second and so on.

 

Is there a Get function that I've overlooked?

Outcomes