Rex,

>When I add a new record, I get two calls to NewId(), one for UInvDet.iId and one for iLotId, but they both increment the UInvDet record.>

>I am trying to update both UInvDet and UInvLot from this view. UInvLot only really needs to be updated when a new lot number is added.

In the "Default Value" call to NewID(), I recommend explicitly passing the table name (specified in the ID.dbf table). This ensures that NewID() uses the proper record in ID.dbf.

Regards,