Autofill a textbox's value in InfoPath

  • Thread starter Thread starter john padilla
  • Start date Start date
J

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.
 
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
 
Back
Top