FM 6.0: specify the lookup record from multiple matching records
Hello again! Need some assistance with lookups that have multiple results.
table:Production Log contains portal to table:Production Data. Relationship is joined by Production ID# (auto & unique) and set up to allow creation of records. The only fields in the log are creation date, mod date, creator and ID#. All other info is in the data file: production date, machine, station #, item code, # of cycles, etc.
table:Offline Reject Log contains portal to table:Offline Reject Data. Relationship is joined by Reject ID# (auto & unique) and set up to allow creation of records. These two files are set up way as the Production files.
While in the Offline Reject Log, I enter (in the portal) the production date, machine and station # and the lookup (to the table:Production Data) auto-enters the item code from Production Data. Problem is that we might change a mold in a station resulting in multiple matching records.
I am trying to follow along with Answer # 2270 from the Knowledge Base (link below), but I'm just not getting it. I am substituting zip code with Station #, city with Item Code and state with Machine.
Any assistance would greatly be appreciated.