troubleshooting Question

append correct value from linked sharepoint list field column

Avatar of Fordraiders
FordraidersFlag for United States of America asked on
Microsoft AccessMicrosoft SharePoint
4 Comments1 Solution169 ViewsLast Modified:
access 2010
sharepoint linked table

I have a sharepoint linked table

tbl_Dashboard

In that table is a field called:  Seller_name - it is being linked as a "Number" datatype.
It is a field in sharepoint that is a lookup field type. bound to column1

When i query that data it shows the actual text.
When i try to append this data to table in access, it shows up as a number ?

I need the actual value in the append query not the numeric value..

Thanks
fordraiders
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros