Well, thank you to both of you anyway. :-)

On a related note, the reason I asked was because I was trying to avoid depending
on a pre-created table with the right structure; I'd done this in a solution
a number of years back, and wasn't very fond of having that extra table there.
I was just looking at when a data model gets checked for validity; it seems
that both form.init and form.open (for the form itself, not the prefilters
for the child objects) both run before the data model is checked. My current
hunch is that none of it is checked until a dependent field object requires
it. Regardless, it would seem that you can create the required intermediary
table in init, and index it there, saving you from having to keep that table
lying around somewhere.

I should note that, as Liz I believe mentioned earlier, that that's not a
documented sort of thing, and could vary from version to version. I'm on
11, 411 build. YMMV. But a nifty little trick, IMHO.

Liz McGuire <liz (AT) paradoxcommunity (DOT) com> wrote:

And if you name it like Denn suggests (with a double underscore to
start it), you don't have to delete the table when you're done -
Paradox will do it for you (though I think it deletes on startup
rather than shutdown - could be wrong about that).

Liz


George Nassar wrote: