Defining a Query in the onOpen Function

The following procedure shows you how to define a query in onOpen, which involves inserting fields from a parent object.

To define a query in the onOpen function

1. Define the fields to write to.
2. Define the values to insert into those fields.