>> could it be possibly done by using a single view?
>
>No, views don't work particularly well with more than one update table. While changes appear to work, you get into real problems when you delete one of the n-records. As there's only one deleted flag, this would also delete the parent record which often cascades and deletes all other child records, as well. The rule of thumb is one updateable table per view.
Hi,
Thanks for pointing out this delete problem, although it is not a real problem this time...
The reason I don't want to use grid is because the 1+N records are logically bound as one entity, that is when ADD, 1+N records must be appended at the sametime and the samething apply to deletion.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only