AnsweredAssumed Answered

Searching records in another table

Question asked by ahcho on May 23, 2012
Latest reply on May 23, 2012 by ahcho


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?