how can create foreign key field

[youssriaboelseod]

hi Pen i can't create foreign key to field from extra form in app

already we can create flow for create data in any direction

but how can get data in drop list from another form?

how can do that

or this option is not available now?

[syscom-pen]

hi youssri

this option is not available now. but we will add 2 option: (1) new field: subquery field , you can use another form data like dropdown list . (2) new flow components : in workflow , you can query and set another form record.

after a while , i will update 1.1.2.0 , that include "(1)new field"
"(2)new componets" will in 1.2.0.0.

thanks.

[youssriaboelseod]

thanks Pen for your respond

i with you for first choice to add sql query (as low level) to alter tables in database to create relation between tow tables

kindly not use Django process for managing database in this issue because Django process (as high level)will increase the complications

for example for complications for using django process to manage database

this production folder in flow models will be error in long term

i suggest ( it should be store outside core folders for not recreate again for manual migrate ( i suggest add copy and delete models for that outside core folders every deployed)

also the name of work flow should be friendly names (not code )to can reuse this name again in tracing this names in database for advanced purpose as transform data for machine learning modules