If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Removing data from table
First, do a backup!
If you edit the relationship between your master and child table(s) and check the box for Cascade Delete Related Records, when you delete a record in the master table the child records are automatically deleted. If you do not have this option enabled and you have set Referential Integrity (which you usually should do), you will not be able to delete a master record that has child records, you will have to delete the child records first. Steve "mbing916" wrote: I am a new access user. I have two tables, the master and the other table. What is the best way to remove all the records in the other table from the master? I am struggling with how to word the query. Thanks. |
Thread Tools | |
Display Modes | |
|
|