Drop down box script
I have a drop down list containing part numbers, is there a way of when selecting a part number, I can get the supplier primary key code?
There are multiple ways. The drop down can be a global field with a script that finds a part record. The drop down field can be a match field to your parts table--which in turn would have a foreing key field with the supplier's primary key code in it that then displays the value on your layout.
Retrieving data ...