Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
cascading changes mean that if the primary key is modified in the parent table, the change will be cascasded in the child table also. It doesn't mean that if you add a new record in the parent table, it would also be added in the child. You will need to do a separate insert in the child table to be able to access the record.
HTH
> I'm using one form to display results from 2 diff tables, they are related by a serial #, and that # is set as primary key for both tables. I've got RI set so that the parent table should cascade any changes to the child table. However, when I go to add a record on the form, I can enter all the info for the parent table just fine...but I cant even click into the fields having to do with the child table. So I went ahead and saved the current record, when I went to browse the tables, the serial # had NOT been cascaded to the child table, so I couldn't even edit those fields on the form until I PUT a serial # into the child table. HEEEELP I know I'm just not thinking things through correctly, or missing some basic point here, but I'm not sure where to get started researching and looking things up to make this work...in other words, ANY assistance would help immensely!:)
Précédent
Suivant
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