I am trying to create a script that will auto-fill a Model based on the manufacturer and serial number entered if it exists in the list of models.
Table: Model Lookup
MacBook Pro (Retina, 15-inch, Mid 2014)
MacBook Pro (Retina, 15-inch, Late 2013)
If I have a serial number, "C02MN1JHFD58" I'd like to be able to somehow search the above table, the table find "FD58" and return "MacBook Pro (Retina, 15-inch, Late 2013)"
What is the best way to do this in filemaker? I have the following script:
Set Variable[$Manufacturer; Value:Assets::Manufacturer]
Set Variable[$SerialNumber; Value:Assets::Serial Number]
Go to Layout ["Model Lookup" (Model Lookup)]
Model Lookup::Manufacturer =$Manufacturer
Model Lookup::Serial Number =*$SerialNumber
Unfortunately, the *$SerialNumber is exactly opposite of what I'd like to do...I need it to be $SerialNumber = *Model Lookup::Serial Number*