I like this approach but it appears that when I try this.. It appears to lose information about my data enviroment for the table Family.. For example, I have a column on my Family table called sortnm, after I run this technique as documented it indicates that variable sortnm is not found.. Help.

Code for the add button listed below

SET SAFETY OFF
SELECT max(familyid) as maxfid;
FROM Family ;
INTO dbf\cJunk
m.famid = cJunk.maxfid + 1
insert into family (familyid) values(famid)

THISFORM.PageFrame1.Page1.Grid1.Refresh()