If I understand correctly, that is no problem at all so far.
QlikView will most probably do all this for you.
I assume the Client_ID is present in the table where there is the name?
=> You just have to make sure that field (with the ID) has the same name in both tables, then it will be automatically linked => when you select one ID on the GUI, then the field >name< from the other table will be automatically pre-selected.
Just add two fields (ID and name) to the GUI and if the tables are linked (you can check this in the table_viewer which you call by pressing Ctrl+T), then it will work.
HTH
P.S.: You can also select multiple IDs, then multiple names will become available - but there is no way then to tell which name links to which ID. To achieve this, you'd have to load both tables multiple times and rename all the fields or use QUALIFY to make sure the tables do not form a large synthetic key (because of QlikView's function to automatically link fields that have the same name)
i already did these steps linked these two tables by ID
My requirement is that i have 5 input BOX i each input box i can enter an ID (in each input box created i can enter variable
example for the first input box (vClientID1) ,second input Box (vClientID2)...)
i want to create 5 txt box to show for each ClientID his name my problem is when i enter one ClientID into the input Box it shows me this client name in ALL my 5 text box.
i want to show in the first text Box (first Client Name)
well, if you have just one set of tables and, you can have as many listboxes as you like - they will necessarily all query the very same field, so any selection in one of them will be reflected in all of them.
The only way I can think of - apart from generating five identical sets of tables and making sure they are not all interlinking, which will be a lot of work - is by using alternate states.
Unfortunately I don't have any experience with that, though. It's too complicated for the target_group of my apps, so I have never done it. Using that you can make different selections on the same field - I don't know if you can push that up to five.
I hope someone else is going to read this who can help you on with that approach.
