using other databases for lookups

[Thunder Poet]

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?

[andy_12-12]

I can only second this request.
To be able to have a drop down look up from the ft_accounts table.