Forum Discussion

BishwaR's avatar
BishwaR
Helper V
4 years ago
Solved

Three Parameters

I have three parameters Invoice Number, City and Country.

When I select a value in Invoice Number how can I automatically get the related City and Country picked up in other 2 parameters ?

 

Invoice Number is a distinct value but the other two parameters do not have the distinct values.

 

For example:

 

Invoice Number     City          Country

 001                        Dallas        USA

 002                        London      UK

 003                        Dallas        USA

 004                        London      UK

 

So when I select Invoice Number 001 it should pick up automatically City = Dallas and Country = USA

 

Is it even possible ?

Thank you

 

 

 

 

 

 

2 Replies