Access Express Australia October 2024
This October, Crystal Long (MS Access Gurus) will be taking us for a deep dive into Access Table Relationships.
We’ll explore the object model and how to document relationships in Access databases using VBA. And we’ll look at the indexes required to support relationships and even some of the undocumented options for relationships.
Kent will show us how to document relationships in SQL Server using system views.
Post Presentation Discussion
After our short(ish) presentation we can have a discussion about the various options like cascading update and delete.
Can I use cascading updates in a relationship based on multiple fields using Natural Keys?
Simple answer is yes. Generally I’d advise againt using multiple fields in a relationship and I’d advise against using Natural Keys
But you may have a use case where you think it may be a good idea. What is a Natural Key I hear you ask?
This and other burning questions will be open for discussion. So come along and prepare to get involved.
See you on Friday October 18. 11.30 a.m. AEST (GMT +10) Note: we don’t do daylight saving time here in Queensland… it fades the curtains.
Join Zoom Meeting
https://us06web.zoom.us/j/82428371009?pwd=zKshKjls4ejcermlUr5zYKB7oavTpM.1
Meeting ID: 824 2837 1009
Passcode: 123456
You can download the demo app for last month’s Control Tip Text here