I need to create an empty stock (voorraad) record after inserting an article record.
So in the Row_Inserted event of the Article table I have:
string sInsertSql = "INSERT INTO Voorraad (artikelnummer, locatie, aantal) VALUES ([Artikelen.Artikelnummer], 'EM', 0)";
ew_Execute(sInsertSql);
But Artikelen.Artikelnummer is not recognized.
I tried x_Artikelnummer and some other things, but I can't get it to work.
What should I use there? (I'm new to this ;-) )
Thx