Open record from other table by after update script
I have a table called "incidenten" and a field to add text to a log-field and certain words trigger other fields to be set a certain value.
Now I also have a table called "Eenheden". When I typ ".geo ON2103" in a field in the incidenten table then I need the record to open from "Eenheden" where the field "Roepnummer" is "ON2103". How do I script that?
5 replies
-
Something like this:
let i := first(select Eenheden where Roepnummer like "ON2103")
openRecord(i)
Steven.
-
Thanks for your reply. Now it searches for ON2103 but it needs to search whatever text is in that field. The fieldname is "Toevoegen"
-
In the trigger after update of that field Toevoegen, or in a separate button, you can put this:
let s := Toevoegen;
let i := first(select Eenheden where Roepnummer like s);
openRecord(i)
Steven
-
Thanks a lot! Seems to work
-
Geweldig, graag gedaan Stijn.
Steven.
Content aside
- 4 yrs agoLast active
- 5Replies
- 1157Views