I've added a lookup field to a document library, and it is possible to choose values as expected in "Edit properties" for a single document. However, when in Edit in Datasheet mode all of the dropdowns for the lookup field are EMPTY!!!! Is this just the way it is, or have I done something wrong?
Has anyone managed to get lookup fields to work in Edit in Datasheet mode?