Re: Still trying to clear cobwebs...


Almost forgot a key detail (sorry about that!) The criteria I'd like to filter
on is not in the child table, but in another related table that is M:1 to
the child. That would be why I'm not using a setRange() or the like.

"George Nassar" <george.DELETEMEnassar@xxxxxxxxx> wrote:
>
>So, I have a 2-table form, where the child table is presented in a table
UIO.
> I'd like to display only particular records from the child table on the
>form. (Clearly, only those related to the parent show, but I'd like to
restrict
>it further.) But if I based the table UIO on a query, I don't have a key
>field to bind the parent to. I considered leaving the parent records off
>the form and making a filter field where the client could sort by parent,
>so I could do my own filtering as well when the client entered the parent
>record, but I really don't want to lose the convenience of navigating the
>parent records with the next/prev record buttons. Am I pretty much stuck
>with running the query on form.open (or form.init, i imagine) to a temp
table,
>adding an index to the table, and basing the form's data model on that?

>(Would that even work? When in the open process does the form check the
>existence of the tables in the data model?) Or is there a better way to
>filter records out of a table UIO that I haven't been able to recall yet?

.