Searching records in another table
Here's my stumper for the day. I have the following table structure
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?