I have a base that has a number of junction tables. For example a product links to a product assembly item that links to a product assembly with multible product assembly items which links to an estimate.
Its very cumbersom to have to go through each of these tables and use the forms to add data to each indivdual table. I wanted to create a single form that lets a user select products and then creates all the related junction tables.
I was wondering if anyone had any work arounds for being able to add data to multible tables from a form. Right now forms do not allow for record creation or buttons with scripts, making it hard to create a new junction table entry that relates to the record being created.
The only work around I can see is to create a seperate dummy " input table" that has a number of records related to each ipnut action I would like. Instead of creating a record users would just be editing the record through an interface. There would then be a script button that would go through and create all the records and related junction table records.
