OK in messing with entering data manually through the subform on the Orders table it appears to work, however when I look at the Order Details table it appears to enter the OrderID as 40 instead of 1040 for example. I changed the Format of OrderID in the Order Details table to \1000 to mirror...