Is there a way to automatically create a new record in a child form? For example, take the free invoice database Brendan provided. If I enter a new item in the invoice, can it create a new record in the products form with the information provided in the invoice? Or update an existing record with a new inventory quantity? (there isn’t any inventory tracked in the sample database, but I need to be able to track current inventory)
Hi Jeff,
You could do this with a Form Script. But it would take some time and thought into exactly how you want it to work.
But certainly a script can copy values from one form, create a record in another form and then set those values into the record in the other form.
I don’t have time to write the script for you though, but you could look at the scripting information here:
https://www.tapforms.com/help-mac/5.3/en/topic/scripts
And the Scripting 101 tutorial by TL Ford, which is linked from my support page:
Support
Thanks,
Brendan
.
