Handling foreign keys in database studio tables
Database studio tables are AWESOME. Unbelievably good and killer feature.
But here's the thing. I am a software engineer with strong database expertise leveraging windmill to quickly input data for my side hustle. I really want to have a dropdown or some other convenient way to constrain values in my foreign key columns when inputting a new row.
Wondering if they're is a standardized way to do this in windmill?
If not, is there a suggested workflow here? Perhaps a hack would be to generate a link to a form for inputting the data.
But here's the thing. I am a software engineer with strong database expertise leveraging windmill to quickly input data for my side hustle. I really want to have a dropdown or some other convenient way to constrain values in my foreign key columns when inputting a new row.
Wondering if they're is a standardized way to do this in windmill?
If not, is there a suggested workflow here? Perhaps a hack would be to generate a link to a form for inputting the data.
