SharePoint list Lookup Column

Question

I’m facing an issue while working with two SharePoint lists: (Purchase Requisition) and (List Item). I created a (Lookup column) in the (List Item) list to pull the (ID) values from the (Purchase Requisition) list.

Here’s what I did:

1. In the List Item list, I created a column called (PRID).
2. For this column, I selected (Purchase Requisition) as the source list and chose the (ID) column to display.

However, after creating the column, instead of the (ID) values from the (Purchase Requisition) list showing up, the (PRID) column is displaying the (ID) as a Choice field. Below is the image how values are reflecting in my SharePoint list:

I’ve checked the column settings and everything seems to be configured correctly, but I’m still getting this issue. Has anyone experienced something similar? How can I ensure that the (PRID) column correctly shows the (ID) value instead of a (Choice)? Thanks in advance for your help!

Below is the image how values are reflecting in my SharePoint list:

Purchase list image:

Answer 1

Since you have created PRID column by choosing Purchase list and ID column during column creation, it is showing the same ID in your dropdown in Line Items list.

To confirm, you can save the data in Line Items list and click on the PRID column value in the list view, it should redirect you to that Purchase List Item having same ID (you selected in Line Items List item).

Answer 2

When users create a new item in your target list, they will see a dropdown menu for the Lookup Choice column, displaying the choices retrieved from the source list. Users can select one or multiple values (depending on your configuration) from the predefined set of choices.