Hi,

I'm planning to use wordpress with wpDataTables for my web site.

I have a table with some values in it, there are approx 2000 records. The table has code + description. In another table I'd like to create a foreign key to the first table. I've seen how to do that in your videos and it works great.

However it is a drop down list which with 2k records is a bit painful to use as there is a lot of scrolling. I'm wondering if you have a way to support a 'combobox' type of behaviour. Do you know what I mean? Where you type in a text box and it refines the results from the combo box. So lets say it was countries if you typed FR it would reduce the list to France, French Ghana, etc. 

In addition to that but kind of related. If that was possible is it possible to have a field that you can select from a dropdown or combobox but also type you're own value. So lets say there is a list of countries but it doesn't include South Sudan (which is pretty new country), so you can type in South Sudan instead of selecting a value. The list of countries would ideally be in another table. So the relationship isn't a Foreign key but the table of values is used to aid/validate the input.

If you could let me know what you think and if it is possible, 

Kind regards 

Pete