[AccessD] Nested DataSheet Views

[Arthur Fuller]

I found it, and I was wrong in saying that Access jumps to conclusions. It
does not. It obeys what I told it to do; I simply forgot where and when I
told it.
The answer is that it's located on the Properties pane when you view a
table in Design mode. There are three properties there that create this
behaviour: Subdatasheet Name, Link Child Fields, and Link Master Fields.


On Sun, Mar 19, 2023 at 3:56 AM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Access jumps to conclusions, it seems, when deciding the way to nest
> datasheet views. I can't locate where that relationship is stored. It is
> certainly not visible in the Relationships window. Right-clicking on the
> sub-datasheet doesn't work either.
>
> Anyone know where this is stored? And how I can remove it and/or replace
> it?
>
> --
> Arthur
>
>

-- 
Arthur