Hello All
I have created a table called MODEL and I have created a page called MODEL VERSION LIST and MODEL VERSION CARD whose source table are ITEM table.I have also created a page called MAKE LIST and MAKE MODEL whose source table are MODEL table.The field Model Code are used in ITEM and MODEL table as well.
What I am trying to do is, I am trying to delete the item record from the MODEL VERSION LIST that are not used in ITEM table.
I have written the code on MODEL table in OnDelete trigger as
item.setrange("model code","code");
if item.findfirst then begin
ERROR('The model code is in use.It cannot be deleted from the item table');
end;
But the code does not seem to be working at all.
*This post is locked for comments
I have the same question (0)
