Hi,
I made a form which contains two grid controls
- one displays Source , the other displays Target.
I used drag and drop method to carry any date from the source grid onto the target grid.
The Source grid¡¯s control source is a table which has medicine_code, medicine_name, Date fields.
The Target grid¡¯s control source is a Local View which has medicine_code, patient_ID, Date fields.
And the view is a parameterized one which varies according to certain Patient_ID and Date.
I just wanted to display medicine_code (which is dragged from the source grid) on the Target grid And also the proper medicine_name in accordance with the medicine_code.
It was easy to show the medicine_code onto the target but it was hard for me to display The other (medicine_name) in accordance with the medicine_code.

The target grid has only two columns(medicine_code, medicine_name)
I¡¯m not sure but I guess this¡¯s related SQL-join condition of the view or there might be Another way to get around.
How do I get the exact result?
Would you please Help me?
Thanks!!