Using the foreign key to access large drop down menus
I have been trying to figure out how to write a script that will let me use the original field to access large drop down menu instead of the foreign key.
I have a large customer list and customer equipment list in a drop down menu what I do now is use a barcode system with the foreign key to access equipment fast.
On my layout I have a text field set as the foreign key, as long as I know what the foreign key is everything works perfect, I enter the foreign key and the exact machine pops up, what i want to do is change from using the foreign key and use the equipment serial number, so instead of using a foreign key of 10 I could instead use a serial number of 97898FT1.
I am thinking I have to use a global field but not sure how to do it, does anyone have any ideals.