Hi,

I think that i have some problem on the relationship between my table. I have attached my database for help.

Machine:{MachineID(PK), MachineNumber}
Inventory:{InventoryID(PK), InventoryType,}
Staff:{StaffID(PK), Shift}
Transaction:{TransactionID(PK), Date, InvIN, InvOUT, Remarks, OperatorID(FK), InventoryID(FK),MachineID(FK)}

When i type in the data in the table 1 by 1 the error does not appear but when i type in from a form the error occur.
Please help me solve this problem... Thank...