>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!!
Hi Kim,
Include the medicine_name in view as !updatable. I think it would be easiest.
Cetin