Thanks Nancy for your reply. Your note was very helpful. Now, I feel much better about knowing my WHERE statement is solid and I am supposed to have the form pop up when I "browse" the view, b/c the paramert doesn't exist.

You mentioned testing P-views.

How do you test test them?

1. when the form pops up and prompts me for a paramter, I can type in the parameter I set in the WHERE statment (lnParenid, which is actually orders.norderid). If I do that, it will return all the values that match the parameter, correct?


Since I'm typing, I have another question that pertains to this.

Since I have the SQL statement all squared away, I now need to go to the form designer and create this form.

When I create the form, I am going to open up the data environment and pull my orders table and my extended_price_detail view into the data environment.

I will throw all the field from my orders table onto the form, and then drag the view to the bottom of the form.

So far so good..

The part that I am unsure about is setting up the properties so that everything works correctly.

My question is concerning the refresh statement Erik gave me, which reads:

?orders.norderid = orders.norderid
REQUERY(extended_price_detail)
THISFORM.extended_price_detail.Refresh()

Where in the properties box do I type this code?

I need to type this code in for each textbox in the parent table that is updated? correct?


I am just a little confused about setting up the grid and having it relate to the orders textboxes on the form, so that when I select a customer, all the information is updated.