>>Hi, Jayesh
>>I have no problem with primary keys and I have clear understanding how they works. My problem is slightly different: if I have a view based on above tables, can I actually add records to it? To be more precise, how SQL updates works when you need to add new records to a view? Will it create new records in all files?
>>Please, give me some advice...
>>Thanks
>>Leo
>
>Please forward me any context regarding this problem.
>
>But I believe that complex views can't be used for adding or editing.
>If yes, please clear my confussion.
>Thanks
>Aashish

Only one table can be updated from a view.