[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

Lookup field not translating between Access 2007 database and MOSS 2007 lists

When I export and link my tables from Access 2007 into Sharepoint, all of the lookups disappear. For example, a filtered lookup (query) for values of type number meeting a certain criteria, only show up in Sharepoint as a column of type number and uses a text box rather than a drop down displaying multiple values returned by the filtered query. What can i do to solve this?
0
BobHavertyComh
Asked:
BobHavertyComh
1 Solution
 
Micheal HuntCommented:
Tables that use a query to lookup values do not transfer the query when moving to SharePoint.  If you use a value list for the lookup in your table, that list will be transfered, but not the results of a query.  Unfortunately, this is a limitation of the transfer process.

Here's an article that goes into more depth about the limitations of transfering tables from Access to SharePoint: http://office.microsoft.com/en-us/access-help/export-a-table-or-query-to-a-sharepoint-site-HA001230314.aspx
0
 
BobHavertyComhAuthor Commented:
Thanks for the definitive answer to prevent me from chasing something that isn't do-able.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now