My problem is that one list from Sharepoint in Access is showing a number in the field instead of the user's first and last name. The particular field with the first and last name is a lookup field that looks up a concatenated field. For instance....
Last,First is the original column
concatenated above to First Last
List looks up to the concatenated First Last name field.
As mentioned, Access is displaying 1035 instead of my first and last name (for my name for example). I saw a workaround for this by importing the two lists at the same time, which works. Only problem is I need this data to be real-time/up-to-date and therefore my Access tables are all linked.
Any suggestions on how to keep the tables linked yet show the display value instead of the ID number?