InfoPath 2010, read & write to Access 2010 -

i have infopath 2010 form i've created submit data access 2010 database. 1 specific element being captured employee id. so, database may have multiple records of same employee id.

i have second table in database, contains every employee id in 1 column , name in another.

if user creating record employee id 987, how add textbox form read corresponding name found in table 2?

thank you,

jeff

here using procedure in fetching data list. try whether working ms access

if need fetch data using infopath2010 use following condition

in rules add action

under run these action add set field value

in field box select fetch details wand display (i.e txt box)

click calculted value (fx) in value

in click insert field or group , select show advance view

under field select table need fetch data

select field need display in selected txt box , using filter condition filter data using secondary table employee id= employee id in main field

secondary table visible in infopath form if connected using manage data connection in infopath