Autofill a textbox's value in InfoPath

[john padilla]

I have been trying to figure this out without using any
JSCRIPT. I am using a MSSQL database. I have a table
called Cities which contains 2 fields: city and state.
When I select the City I would like the state field to
get filled from the state field for the same record.

Here is more additional information. I have a table
called demographic. demographic has fields for state and
city which i want pushed in from the Cities table. I
tied, in the city field (dropdown list) under demographic
table. to use the city records from the city table
(source). This works. But when I select a city i do not
get the state (state field in dempographic uses same data
connection as City but i have selected it to use the
state field only) to autofill.

I haven't come by an example of this and so far my
attempts to accomplish this has failed.

Please email me any detailed suggestions.

 

[Arvin Meyer]

My limited experimentation with InfoPath has convinced me that many complex
database tasks which are accomplished quite easily in Access are difficult
to impossible in InfoPath. A few tasks, like simple validation are easier.
You'll get better results though, from an InfoPath newsgroup. Try:

microsoft.public.infopath

If you find your answer, many of us would appreciate knowing it. Kindly post
it back to this thread.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access