My Combo Box Is Not Looking Up Values From The Data Source

[R Tanner]

Hi,

I have a Combo box which I have set to look up values from the form's
data source. In the entries field, I have the following:

/dfs:myFields/dfs:dataFields/dending_Tickets/d:Managers

In the Value Field, I have:

@ID

In the Display Name field, I have:

@Manager

The data source for this form is an access database. I am very
familiar with access, and I have realized that form design is not
really the same at all in InfoPath. Essentially, what I want is to
generate a drop down menu that displays all of the managers, but
enters the ID in the child table. In access, my sql statement would
be the following:

SELECT ID, Manager FROM Managers ORDER BY Manager.Managers;

But when I go to the preview view, I don't have anything in my combo
box...

 

[Swathi (GGK Tech)]

Hi,
Verify that you are getting the values when you execute the sql statement?