Using infopath 2007, and access 2007. I have a drop down list box that that pulls values from another lookup in access database. So I want choose referral Id from the drop down list box. I want pull back the refferalid and one other field from the same table called the master Id.
So I choose one value from by drop down list box and by choosing a certain value another value gets populated.