Hi All,
I am building an app which will use multiple SharePoint lists for different sections of a testing process, the reason for the separate lists is for version control, this will allow us to see the changes made to each section of a testing process.
as a bit of background, we have a SharePoint list (named test data) when a new project is created this list will contain the 'Project Number' field (standard single-line text field), in another list (named requisite) i also have a column which requires the 'Project number' and is setup as a lookup field - pulled from the test data SP list.
What i am looking to achieve is:
if a record already exists in the SP list requisite it will not display that project number in the drop down box
dont even know if this is possible, but any help would be much appreciated! TIA
