How to Set Up Referential Integrity in Microsoft Access. Prevent Deletion of Parent Records.

[@moizrashid6373]

Came for the knowledge, stayed for the star trek references!!

[@599CD]

Nice! LLAP

[@moodkn]

Thanks Sir....! Very well A very important exercise

[@599CD]

Always welcome

[@JstnW]

Thank you! Good stuff

[@599CD]

You're welcome!

[@patrickvancooten7186]

Can you make a video on How to develop a Microsoft Access Preventative Maintenance database? Which logs every maintenance done on each individual equipment and can generate a history list of activities. The reports would be able to produce the reoccurring maintenance of each equipment, the issue of the unit, who it was repaired by date it was repaired, and what was the repairs done. I appreciate you sharing this knowledge and thank you for the lesson.

[@599CD]

That would be very similar to this: 599cd.com/Vehicle

[@stanTrX]

Thanks but many times you dont use such global relationships do you? I used to set these relationships in the beginning but now i dont use this at all but as you just showed it seems to be necessary action.. quite confused :)

[@599CD]

I talk about them a lot more in my full course, but generally no, I don't use them. However they do have their place. Sometimes. :)

[@aradetchemistaradet5650]

good day sir...please i need your help in access 2016 version en ..i want to change alignment in list box access to the right can i ? and there are way to make movement in listbox with next record button or previous

[@599CD]

Align in listbox: nope. Movement: up/down arrows.