D
Daniel
Hi,
I have a major problem with Access forms, I developed a form based on SQL
Server table (.adp file).
I'll describe the tables:
Table Employee (ID, Name etc.)
Table Products (ID, Name etc.)
Table Commisions (EmpID, ProductID, Commision)
Table Employee has an after insert trigger that adds commision records for
each product in the Products table.
The same trigger fiers after addition to the Products table.
So the table Commisions is managed using Triggers only.
The problem is like this: I created a form for the Employee table, but
whenever I want to add an employee i get this messege:
"Key column information insufficient or incorrect. Too many rows were
affected by update"
The data is added to the table but i cant see it in the form. only if i open
it afterwards with this record.
How can i prevent this messege and make the form act normally. like theres
no trigger ?
I have a major problem with Access forms, I developed a form based on SQL
Server table (.adp file).
I'll describe the tables:
Table Employee (ID, Name etc.)
Table Products (ID, Name etc.)
Table Commisions (EmpID, ProductID, Commision)
Table Employee has an after insert trigger that adds commision records for
each product in the Products table.
The same trigger fiers after addition to the Products table.
So the table Commisions is managed using Triggers only.
The problem is like this: I created a form for the Employee table, but
whenever I want to add an employee i get this messege:
"Key column information insufficient or incorrect. Too many rows were
affected by update"
The data is added to the table but i cant see it in the form. only if i open
it afterwards with this record.
How can i prevent this messege and make the form act normally. like theres
no trigger ?