I am using SharePoint On-Prem 2019 and have a list on Site A, with the columns "Equipment Name" and "Serial Number" that I need to be able to lookup on Site B for the Trouble Ticket form. I have third party software that allows me to do a cross site lookup on the Trouble Ticket form which pulls the "Equipment Name" info from Site A (in a drop down list), but I need it to also link to the "Serial Number" column so we know which piece of equipment is being worked on.
Would it be possible to make the two columns associated somehow? Or do a cascading cross site lookup? Any info would be very appreciated.