I’m looking at building an interface to streamline inputting some information but before I think about redesigning my current database I just want to check if it’s possible to create an interface that would allow information to be updated across multiple tables?
Even more complicated, would it be possible for the interface to react live to automations?
To try to give a bit of context
I want to have a contract table where the top line contract information is kept - as part of this an automation creates different versions of a product linked to that contract in an editions table…
Could an interface handle me entering the contract detail and then have the editions appear ready to be edited?
