Linking Data Types Problem

Need help Database
1

I am having an issue with linking 2 data types. The 1st data type is “Equipment” and the 2nd data type is “location”. Each “equipment” thin has a “location” thing associated with it.

The equipment data type currently has over 2000 things and most of them have a “location” thing associated. However, when I try to add a new or modify certain ones, I cannot add the location thing using the manual data entry. The location field that I am matching on is called the “Snap”

This is image is from the equipment data type where i type in the location Snap.

Screen Shot 2022-05-08 at 3.23.37 PM
Screen Shot 2022-05-08 at 3.23.37 PM880×106 9.37 KB

This is a location Snap that I am trying to use.

Screen Shot 2022-05-08 at 3.24.19 PM
Screen Shot 2022-05-08 at 3.24.19 PM916×122 2.49 KB

When I type this location Snap into the Equipment Location, it does not accept it. I am not sure what is going on. Again, this works on 1000s of records except for ~15. Not sure what is going on. Any ideas?

2

You probably need to change the search field…

3

I have tried that by using the unique id but with the same results. As I said, it works for other records. It tries to find the Snap as I type in the field box but for whatever reason it can’t find it. I have even tried deleting the location record and adding it back but it still didn’t work.