table access in a script
I've read help and another manual but still cannot figure this out. I think I need a trigger to run on commit of a record in a table after data entry which contains fields that can be compared in another table that has a many-to-many relation to the first. The trigger script needs to look up stuff in one of the tables to make a join table entry. So, I have a field to search in "the other table" for which I have the content I need to find the record with the primary key that is to be the foreign key in the join table. So, how do I write a script to search (do a find on) a table for a record and then access fields in the found record?
(I hope that was clear?)