Choice Options property SQL

[jholsombach]

Is this a valid value for the choice options property for a database driven auto-complete?

AAAGT# || ' - ' || (SELECT AGNAME FROM WMAGP WHERE AGCO# = AACO# AND AGFEIN = AAFEIN AND AGMOD = AAMOD)

all are fields above except for WMAGP which is a file.

The idea is i want to populate my autocomplete with "Agent# - Agent Name" value. The agent name coming from a different file (one that does not have agent #, but rather links to agent # via their FEIN and MOD values).

[Brian]

If it does work, I would not recommend doing it this way. The better way to approach this is to create an SQL view that joins your two files and includes the columns you need. Once done, just use this new view instead of your original table in the database property.