2 Replies Latest reply on May 23, 2012 1:34 PM by ahcho

    Searching records in another table



      Searching records in another table


      Here's my stumper for the day. I have the following table structure

      Site Listing>------<Inspections

      Now, I have a layout that has a portal pulling data from Site Listing. Each row in this portal has a button that pulls information from the site listing into a layout based on inspections.

      I would like this button to run a script that sees if an Inspection entry exists for the site loads the entry in the Inspections layout and if it doesn't, create a new record.

      My first few cracks revolved around the Perform Find function but I can't find a way to put the failed status of the Perform Find function into an IF statement.

      How do I go about solving this?