I have a script written that has 3 parameters -- all pointing to the same primary key (pk_IDNumber):
Parameter Name #1: Client Number 1
Parameter Name #2: Client Number 2
Parameter Name #3: Client Number 3
When the user enters data in the 'Client Number 1' parameter, I also want additional data to print on the report (i.e., client's name and address) that is associated with the primary key of pk_IDNumber for that client. If the user enters data in the 'Client Number 2' parameter, I want the same additional data to print on the report (i.e., client's name and address) that is associated with the pk_IDNumber for that second client.
Can anyone advise me?