Creating New Records in Child Form

[Jeff Diamond]

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)

[Brendan]

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

[Jeff Diamond]

Thank you, Brendan

[Author]

Posts