Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

append correct value from linked sharepoint list field column

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
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fordraiders

ASKER

Pat,
"You need to either join to the table that defines the ID and get the text value from there"

That worked.

Thanks !!
Thanks
You're welcome