Fordraiders
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
You're welcome
ASKER
"You need to either join to the table that defines the ID and get the text value from there"
That worked.
Thanks !!