Is it possible to have a dropdown appear when adding a row in the console/backend UI that includes foreign table data? It does allow you to require NONNULL but when doing so, it seems impossible to save the row because the workflow seems to require selecting the foreign value after saving the row. Must or can this be done via code?
No, this not possible. Our vision for the constraints is those should be established once the app is running without the need to enter data objects manually using console. If you still have a need to do so, then the constraints should be removed. Otherwise, it must be done via code.
Regards,
Mark