What I’ve been doing lately is to use what I’m calling “hybrid” forms:
- show new screen action instead of form screen
- add an input component for any input you want to validate against another table (using relations, etc)
- add a form container beneath the input for the remainder of the form, but only display the form container if the input outside of the form container is “valid”.
This way you still have a form experience with less updates but can still leverage the custom form experience for the one or two inputs that require it.
I have an example somewhere in an app I worked on recently. I’ll see if I can dig it up when I get home this evening.