You might have to do a SAVEROW before your insert to save the header data. That way the column values in the header data get saved and can then be linked to the data in the detail table. Also, just doublecheck that all the common columns have the same data in them.
Karen > I tried this and no rows showed though they were inserted into the temp > table. > > > > INSERT INTO tBOLRows (Control#, Model#, Sortone, Outshipinv, Quantity) + > > SELECT Control#, Model#, Sortone, Outshipinv, Quantity FROM OrderRows + > > WHERE Control# = .vControl > > PROPERTY TABLE tBOLRows 'REFRESH' > > RETURN > > > > jim > > >
