In SharePoint 2007, is there a limit to the number of lookup-fields that you can have in a list?
Asked
Active
Viewed 1,833 times
1 Answers
1
No, however you might want to bear in mind the 'rule of 2000'.
Microsoft states the following:
2,000 columns per document library and 4,096 per list
But these are not hard limits they are prformace guidelines. You can see a full TechNet article on SharePoint architecture and performance limitations here

Charlie
- 2,096
- 2
- 22
- 34
-
That "2000" limit refers to browsing to those lists. If you are going to use a list to e.g. hold data to be queried through an SPQuery, then this limit doesn't hold. – Ariel Jul 13 '09 at 03:21
-
Hence my statement about being performance guidelines not hard limits. – Charlie Jul 14 '09 at 13:51