Just thought I'd provide a brief update. At the top of my post I noted that I was using a .adp file. Despite the fact that I still...

I've made a breakthrough / discovery regarding updatable views in a .adp file that I'm compelled to share for the good of the community. Hopefully this will help someone...

My Report

My idea of creating a FK to both tables and constraining the combo box of the Request Type by the selection in the Request Category still has the same...

Thank you Wendell for your reply. It is as I had feared.

Indexed View

I've tried this to no success (so far) but I wonder if it's because I'm not doing...

I'm happy to report that by creating a view on the server (using OPENQUERY, which makes it nice and quick) and then creating a link to it in my .accdb...

Wendell;

Thank you for your response. I was wondering if I was going to get one. There were a bunch of views but yours is the first response.

A little...

lol! That's totally it. It seemed so much more difficult when I was trying to solve it on my own. Thanks!

That's exactly what I'm looking for. Thanks!

Yep that works! Thanks for the help.

Hi Andrew.

Thanks for this.

I actually came across this solution a few hrs ago on my own. Just hadn't gotten back here to document it for completeness.

Ooh. Good point to note. Thanks.

That's kind of elegance I was thinking of 😛

Thank you!

I think I've got it. I'm just not sure if this is the best solution.

I'm using a function called from a constraint which checks for grandparents.

What do you think?...

Hi GSquared.

Thanks for the reply to my post of a while ago. The final resolution was that, from a business perspective, [coal]Mines and Mine Workings are to be treated...

Please forgive me, I still don't understand what you're saying.

In the example below Table C has two cascading references. SQL...