Buttons and relationships
I have two tables, both with a field that is called "Name", and the two "name" fields are connected in a relationship. In their relationship I have tucked off the the box with the option "Allow creation of records in this table via this relationship".
I have made a button that takes me from one of the first table to the second, and have given the script "Copy "name" " and "Open "second table" ". I want this button to automatically create a new record in the second table, and copy the existing value in "name" from the first table to the second.
Basically what I want with the button is to automatically create a new record in the second table with the name of the person in the first table.