+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: using other databases for lookups (/showthread.php?tid=2597)
using other databases for lookups - Thunder Poet - Sep 3rd, 2013
I have not seen in the documentation or tutorials or in searching these forums a common requirement in Form usage.
A form field that must pull data from another table for lookups, say, in a dropdown selector.
And by this I mean a database table that is pre-existing, not constructed by Form Tools.
And, following that issue, how to auto-fill other fields in the Form tools Form with other values in other fields from this same "external" table.
Example:
Form Tools field -- account_number
Starting to type in the "account_number" field brings up suggestive search values matching what has been typed so far, values that come from another table I already have.
When the desired "account_number" field value has been selected it automatically populates other Form tools form fields from other columns in the lookup table.
I sense your hooks may be the beginning but this would be a very useful tutorial, since this is such a common type of form process these days.
Have any of you users already done something like this?
RE: using other databases for lookups - andy_12-12 - Sep 14th, 2013
I can only second this request.
To be able to have a drop down look up from the ft_accounts table.