First off, I'm a beginner, so I'm probably asking a silly question. I actually hope I am, because it means I'm making things too hard.
I am creating a database in which there is a child table that has two parents. (Which is really just a join table, I know, but my problem still remains.) I need to have the choice of assigning the second parent to the child, or creating a new second parent from the child, in the child layout. No matter what I do, I can't figure out how to make either of those things work. I'm sure it's a scripting thing...and I haven't yet wrapped my head around difficult scripts.
I've attached an example that shows the build I've come up with. Feel free to correct any odd things I've done. I'm really looking forward to figuring this out.