So I'm trying to make a database with a many-to-many relationship. My problem is that I want to populate my join table with a button. So I have my records and my button, but I can't figure out the script steps to take the two important numbers and get them to appear in the join table together. Is it set field? Is that what I want, or is there something that will do this more effectively?
Set variable to put the values in a pair of variables, then set field to assign those values to the new join record after it is created.
You might look at the "check boxes" in this demo file as they are really buttons with conditional formatting and they do what you describe here: