AnsweredAssumed Answered

table access in a script

Question asked by StewartMcadoo on Sep 13, 2012
Latest reply on Sep 13, 2012 by philmodjunk


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?)