>>>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.
No you can, if view primary keys cover both tables. That's another story that it might be confusing but from technical standpoint it should work.
Edward Pikman
Independent Consultant