Can anyone tell me how to create a column in a Sharepoint list that looks up the values of the other documents in the list and shows them as choices?

It's a Topic for a document and I want the user to see a combobox showing a unique list of the values of the Topic column for the documents already in the list and to allow the user to add a new topic if the one they want is not there.

Thanks

Gordon

Hi,

As I understand, you can create a look up column to find the title field in documents list to achieve this requirement.

In my environment, I create a lookup field to the document library field like the capture below:

Thanks

Best Regards

I was trying something like that. The difference is that I don't want the Title field in the lookup, I want to use one of the fields I defined in the list. When I try to do that, the field isn't in the "In this column" box.

Any ideas?

Thanks

Gordon

Hi,

In my environment, I create a single text column named "testcolumn" in the document library. Then in another list I created a look up column, in "In this column" dropdownlist, I can select the field in document library.

Could you please provide the steps how you create the look up field or some screen capture ?

Thanks

Best Regards