Thanks



>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,