Hi!
I have 2 tables with identical fields.
the first one, Orders, contains.. well orders.
these orders can be split up, if the batch is to big to produce it in one day.
when split 2 records are added to the second table, Splitorders.
all orders across the 2 tables have unique IDs called...