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.

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

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks

2 Answers  

---

I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

0 Answers  

---

What is field size access?

0 Answers  

---

What are the several file extensions in ms access?

0 Answers  

---

What is ms access and its components?

0 Answers  

---

Is access faster than excel?

0 Answers  

---

What is microsoft access database engine?

0 Answers  

---

How many columns are in access?

0 Answers  

---

How do access relationships work?

0 Answers  

---

Is there a limitation on the size of a database that can be opened in microsoft access?if yes, what?

0 Answers  

---

Explain how we can do multi-join query in ms access?

0 Answers  

---

Explain table queries and select queries. What are the main differences between the two?

0 Answers  

---