I want to populate a drop down list from a foreign key but I want to create a text box or form to allow users to enter a value because it will be very lengthy. The reason i have a foreign key is i have a table that is a list and then the detailed info the users will put in is stored in a separate table that i can join later.
Example
Users selects from down drop a value
Text box checks to see if anything is in the database and will show the value if there is something. if there isn't something it will be a blank box. They can then enter their text or update if there were values previously.
Foreign Key columns can only have a single-value selectbox, so when you configure the foreign key, you can access the Editing tab and enable the search box:
I want to populate a drop down list from a foreign key but I want to create a text box or form to allow users to enter a value because it will be very lengthy. The reason i have a foreign key is i have a table that is a list and then the detailed info the users will put in is stored in a separate table that i can join later.
Example
Users selects from down drop a value
Text box checks to see if anything is in the database and will show the value if there is something. if there isn't something it will be a blank box. They can then enter their text or update if there were values previously.
Hello Matthew.
Thank you for reaching out to us.
Foreign Key columns can only have a single-value selectbox, so when you configure the foreign key, you can access the Editing tab and enable the search box:
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables