Can you create a updatecascade, Deletecascade relation in
Ms-Access? If yes, give an example?
Answers were Sorted based on User's Feedback
Answer / upendra agnihotram
Yes. You CAN. you need to set the referential integrity in
Relations window in MS Access. When you add a relation to a
table, you will be prompted through Edit relations window
where you can set the cascade updates and cascade deletions.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / susi kumar.p
After make ensure of having unique index for setting up
the "Enforce referential integrity" at relationships in MS
access we Can create a updatecascade, Deletecascade
relation in Ms-Access.
Try and let to share.
Note:- Good Upendra.A
Is This Answer Correct ? | 1 Yes | 1 No |
What are the limitations of ms access?
How do I use excel as a access database?
Difference between superior keys and candidate keys?
How you can export data in excel format?
What is recordset in ms access?
What format should my database be saved in to allow different versions of Microsoft Access to open the database?
What are the several methods to enter data in ms access 2013?
What is the best alternative to microsoft access?
How do I start microsoft access?
Would you easily automate your ms access database through menu driven selections?
How a table can be created using microsoft access object library (maol)?
can we call primary key a 'address'????