help with script to set field from current record in another table
I have an INCOME table which I am browsing. I'm trying to create a script that will create a new record in another table, MEMBERS, using some fields from the current record I'm viewing in the INCOME table.
I've created a script to do this, but I haven't figured out how to get the script to take the source fields from the current record in INCOME. It seems to use some arbitrary record in INCOME as the source.
What would be the simplest script to create a new record in MEMBERS, and set field "name_last" equal to the value of "name_last" in the currently viewed record of my INCOME table? Thanks!
(I'm using FM Pro 10 Adv Mac.)