Hi,

I wrote a script for a button that is intended to create a related record in a new table. The logic of the script is supposed to be:

1. If there is no related record in "Monitoring Data Entry", then create one and automatically populate three fields.

2. If there is a related record, go to it.

It works most of the time, but for some reason, some records end up with two related records, and usually the second does not have the correct values for the fields I am trying to auto-populate (mdeNestID and mdeSpecies). I have attached the script as a jpeg. Any advice on why it does not quite work correctly is much appreciated!

Edited August 20, 201015 yr by Guest

We also need to see the relationship diagram for "Monitoring Data Entry"

Well that makes sense - sorry I didn't include it originally. "Thesis Data" is where the button is located. "Monitoring Data Entry" is where a new record is created or an existing record is pulled up when the button is pressed. Each record in "Monitoring Data Entry" is basically a header that sits over a portal to "Monitoring Data."

In the relationship graph, it goes:

ThesisData->MonData->MonDataEntry

I've attached a jpeg for the ThesisData->MonData relationship, and one for the MonData->MonDataEntry relationship.