Albert: I cannot believe after umpteen years of RBase programming that I had NO CLUE you could use the "nonum" to insert into an autonumbered column!!!! I would have a separate one-column autonumbered table where I grabbed my "next", with no autonumber on the real table ....
Thanks for the Christmas present! Karen > INSERT INTO Invoices (col list here) + > SELECT InvNo, <and the rest> + > FROM InvEntry NONUM
