@Rob_Cahill, just to clarify: It’s only “impossible” using Airtable’s native features that are built into a single form.
But there are tons of different workarounds for this, because this is a very common request that many people need.
@kuovonne and I outlined only 3 workarounds above. But there are many more workarounds as well, in addition to the 3 listed above.
You might even be able to do what you want with On2Air: Forms, but I would ask @openside about that.
So you have tons of options for making this work.
p.s. If you have a budget for this project and you’d like to hire an expert Airtable consultant to figure this out for you & program it for you, feel free to send me a private message.