Versions des environnements
>> 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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement