I have 2 Lists.
In first list i have 2 columns called ProjectID,project title In second list i have same 2 columns
Requirement: When i select project title in second list,The projetc ID should auto populate based on Project title selection
Briefly, Once the Project Title is selected, the Project ID should auto-populate based on which project is selected.
Project iD is the primary key in first list and foreign key in second list
Your help is highly appreciated.