Order form + 3 connected tables

Hello Airtable Community,

I have started using this amazing tool a few weeks ago and I still have a lot to learn.

That being said, I am working on a order form with many fields. The order form part is right but now I am thinking about usability.
What I mean is that I would like to be able to break the data coming from the form into 3 tables (Customer, Taxes, Invoices) and I would need these 3 tables to be in sync (e.g. when I filter things in one table, the second and third one should change accordingly).
I have been exploring the “link to record” function with poor results: when the data from the form come in, they are captured only in the first table even if there are linked records in the second one.
As a summary, I would like to get the data from the form spread across 3 synched tables.

Sorry if my need is confusing. Happy to provide more info.
Thanks to anyone who will be so kind to invest some time on me :slight_smile: