G
Guest
I have a main form (enter_RMA) with a subform (Ord_Line) linked by the
RMA_ID. The main form has customer info, order date, ship date, order
status, etc. The subform has specific order data. For example on the
subform - the user chooses a part_id, the qty (Quantity), and some other data
is automatically populated based on the part_id. If the order contains more
than 1 part the user goes to the next line and repeats the process till all
the parts are ordered. There is a field called Line_No which has to be
entered. Right now the user has to manually enter a new line number. Is
there a way to automatically have the Line_No increment by 1 each time a new
part is added to the order?
RMA_ID. The main form has customer info, order date, ship date, order
status, etc. The subform has specific order data. For example on the
subform - the user chooses a part_id, the qty (Quantity), and some other data
is automatically populated based on the part_id. If the order contains more
than 1 part the user goes to the next line and repeats the process till all
the parts are ordered. There is a field called Line_No which has to be
entered. Right now the user has to manually enter a new line number. Is
there a way to automatically have the Line_No increment by 1 each time a new
part is added to the order?