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...

Thanks for the reply.

I'm not sure what you're saying. Am I reading you to say that cascading can only go to one table? That's not correct otherwise the...

After much gnashing and trashing I think I've got this solved. Here's the code for posterity sake. Maybe it'll help someone else some day.

-----------------------------------------------------------------------------------------------

-- GET STAFF_ID (User defined...

Hi.

I've tried to take a slightly different tack and am now having a different problem. I'm trying to use a function to perform a check constraint. Logically, I...