I have two lists,
A-list :
- there we set up cost acceptance requests which are used to describe invoices, they are numbered
list B
- list of invoices, where we use the approval number from list A for the description (we enter this number in one of the fields)
I have been asked if it is possible to compare the two lists, so that in the list, next to the number of the approval that has already been used in list B, there would be some kind of marking, for example "Used".
Is it possible to create something like this? Because frankly I have no idea
Best regards