I think my explanation was not proper last time.
I made a view(named as myview) whose SQL code is as the followings,

SELECT target.*, source.medicine_name;
FROM hospital!target LEFT OUTER JOIN hospital!source ;
ON target.medicine_code = source.medicine_code

After I let the ¡°source.medicine_name¡± as not updatable on the view
Designer,
I tried to do as the followings,

Append Blank
Replace myview.code with something
Replace myview.pa_id with something
Replace myview.Date with date()

But it generate an error like ¡°Can not insert an empty row from a view into it¡¯s base table.¡±
Whenever I try to requery().
As I told you, I used grid controls and it does not display medicine_name dynamically
according to the Change of medicine_code.

There are two tables related to this topic.
One is the basic list of medicines and it¡¯s code.
The other is a list of medicines needed for certain person.

Well I¡¯m still haven¡¯t found what I¡¯m looking for.


>Hi Kim,
>Include the medicine_name in view as !updatable. I think it would be easiest.
>Cetin