Sharepoint Lookup data field displays Id not data

[ap1971]

Using Access 2007 to create a report from Sharepoint data. When I create a
report using wizard or if I create my own text field using other fields, the
displayed information is the Id field not the data in the record? If I add
the field from the "Add Existing Fields" link at the Ribbon it works. Any
suggestions? Not so much of an issue if the field is entered, however if
does create an issue if I am trying to string fields together for a better
look.

 

[Albert D. Kallal]

Using Access 2007 to create a report from Sharepoint data. When I create
a
report using wizard or if I create my own text field using other fields,
the
displayed information is the Id field not the data in the record? If I
add
the field from the "Add Existing Fields" link at the Ribbon it works. Any
suggestions? Not so much of an issue if the field is entered, however if
does create an issue if I am trying to string fields together for a better
look.

When you do this two different ways, have you looked at the data source of
the text box after you have placed it on the form? there should be something
different in regards to how the data source of the text box looks....