Why in Transactional Replication would I receive the error:

Cannot insert the value NULL into column 'InvoiceItemNumber', table
'Newsline2.dbo.dbo_HomeInvoiceDetail'; column does not allow nulls. INSERT
fails.

When 'InvoiceItemNumber' is a Primary Key column on both Pub and Sub.

Help.

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page