Hello list,
would you help me with apparently elementary issue. I'm trying the afteradd event to insert primary autoincremental field value into another table with another primary autoincremental key.
Let's see the details:
parent table1:
field1 int autoinc primary key
field2 int
child table2:
field3 int autoinc primary key
field4 int foreign key (table2 is the child to the table1 on field1)
Evidently, if I use before add event, I receive '0' as the value inserted because this value does not exist before record is added.
If I place the same code as the after add event, for some reason I receive the errors that mention other fields not included in code. Does anybody have such an experience?