> >> We've mentioned a several occasions that buffering is now the way to go > >> instead of scatter. > >> > >> But, in the situation where the user is doing a data entry in the > temporary > >> table which has the same structure has the master table, and we then use > a > >> transfer button to move the record from the temporary table into the > master > >> table, isn't the only way to go scatter and gather? > > > >Why not SELECT INTO ARRAY, INSERT FROM ARRAY? > > Is this a better approach than scatter and gather? As Vlad & I were 'discussing' yesterday, this may be a better approach if you're dealing with the possibility of multiple child records. If you're dealing with single records, then it is probably not the best way to go. /Paul