Hi Nancy -

I took the advice that you and Erik Moore gave me and parameterized my view. I went to the command window and issued a new
CREATE SQL View, and when I was done, overwrote it.

It appeared to work fine.

I need to issue a REQUERY()
(1)Where do I issue this command?

Erik mentioned in his post I needed to set the lnParentId (which is orders.norderid) to the pk of the parent table (which is orders), and then requery the view.

(2)Can I do that in the view designer?, or is this proceedure done in the properties form in the form designer?

Thanks again Nancy for the help!

Jason