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?