Trouble adding new records related to current record.
Hello FM forum. I have been pulling my hair out trying to figure out how to make this work. It's been very difficult finding an answer in a forum. For this issue I am using 3 tables. There are 5 in the screen shot but disregard Inventory and Fund 2 for this issue. All the main data sits in the Property table. Then the financials used are in their own table. When I am in a record from the property table I created a button on the form that runs a script that says "Add Offer" This script is supposed to add a record in the financialsREO table, copy the propertyID from the financials table(that is my relationship), and also copy the field ARV from the financials table into the financials REO table. For the life of me I cannot get any data to move over. I have the table field set to look-up and did a set field in my script. Can anyone please help me get sleep at night? I am including a pic of my table relationships.