AnsweredAssumed Answered

Using the foreign key to access large drop down menus

Question asked by user14040 on Sep 6, 2011
Latest reply on Sep 6, 2011 by philmodjunk

Title

Using the foreign key to access large drop down menus

Post

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.

 

Example:

 

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.

 

Thanks

Outcomes