I have a Orders and Line Items tables that are linked together in the typical parent child relationship where an order has many line items.
My question is how can I append the line item index (+1) to the order number in the line items table?
For exam...