validation rule violations?

[ProgramError]

Hi

I copied the structure of a table to allow adding records to (this works) I now want to combine these tables. I have created a query which should do this but I get the violation error. I add all fields except the primary key as expected.
Any ideas?

INSERT INTO tblEquipment ( RecNum, Make, Model, Serial, PCode, Status, StatusDate, ASTIprefix, MSNumberText, Site, Building, Room, DeptCode, Supplier, OrderNo, [Order Funding], Cost, PurchaseDate, GuarPeriod, LifeExp, ServContExp, ServLevel, Charge, Comments, Loanable, PatTest, Make1, Model1, Description1, ESU1, PolyNo1, [Year Bought1], Location1, Building1, Room1, DeptCode1, Contact1, Department1, Supplier1, OrderNo1 )
SELECT tblTempOrderList.RecNum, tblTempOrderList.Make, tblTempOrderList.Model, tblTempOrderList.Serial, tblTempOrderList.PCode, tblTempOrderList.Status, tblTempOrderList.StatusDate, tblTempOrderList.ASTIprefix, tblTempOrderList.MSNumberText, tblTempOrderList.Site, tblTempOrderList.Building, tblTempOrderList.Room, tblTempOrderList.DeptCode, tblTempOrderList.Supplier, tblTempOrderList.OrderNo, tblTempOrderList.[Order Funding], tblTempOrderList.Cost, tblTempOrderList.PurchaseDate, tblTempOrderList.GuarPeriod, tblTempOrderList.LifeExp, tblTempOrderList.ServContExp, tblTempOrderList.ServLevel, tblTempOrderList.Charge, tblTempOrderList.Comments, tblTempOrderList.Loanable, tblTempOrderList.PatTest, tblTempOrderList.Make1, tblTempOrderList.Model1, tblTempOrderList.Description1, tblTempOrderList.ESU1, tblTempOrderList.PolyNo1, tblTempOrderList.[Year Bought1], tblTempOrderList.Location1, tblTempOrderList.Building1, tblTempOrderList.Room1, tblTempOrderList.DeptCode1, tblTempOrderList.Contact1, tblTempOrderList.Department1, tblTempOrderList.Supplier1, tblTempOrderList.OrderNo1
FROM tblTempOrderList;

Thanks


Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[ProgramError]

I eventually found the information on the microsoft web site. Because one field did not have any information entered it would not allow the data to be appended.



Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.