N
NetworkTrade
A Form it is based on the Master Table.
This Form has two subForms both based on separate Tables that have a basic
1:Many relationship to the Master Table.
i.e. Master Table is Employee info ; first subForm (Table) is Training
Classes that employee has attended; second subForm (Table) is Job Positions
that employee has had previously
very straightforward.
My question is about deleting an employee Record. To delete the employee
from the MasterForm (Table) is easily done and a wizard makes it simple to
use a Delete Record button on the form. But the deletion of the related
child Tables’ records does not occur.
The two child Tables are linked via a unique employee ID field.
I have found previously the Referential Integrity & Cascading features often
to be user unfriendly – often sending error messages due to blank fields that
are not intuitive to the user. Suggestions? What would be the proper syntax
to have a button delete the Parent record and all related Child records in
other Tables?
Thanks……..
This Form has two subForms both based on separate Tables that have a basic
1:Many relationship to the Master Table.
i.e. Master Table is Employee info ; first subForm (Table) is Training
Classes that employee has attended; second subForm (Table) is Job Positions
that employee has had previously
very straightforward.
My question is about deleting an employee Record. To delete the employee
from the MasterForm (Table) is easily done and a wizard makes it simple to
use a Delete Record button on the form. But the deletion of the related
child Tables’ records does not occur.
The two child Tables are linked via a unique employee ID field.
I have found previously the Referential Integrity & Cascading features often
to be user unfriendly – often sending error messages due to blank fields that
are not intuitive to the user. Suggestions? What would be the proper syntax
to have a button delete the Parent record and all related Child records in
other Tables?
Thanks……..