Hi Erik --

First, I want to thank you for the help last week. I certainly learned something last week.

I'd like to take another step this week towards completing my orders-entry form, so I thought I would ask a few more questions.

Just to give you a little background, I have set up a parameterized view to embed in my orders entry form. I created a view called extended_price_detail from my "products" table and my "ordersdetail" table. This view performs the arithmetic for the unit price, unit quantity, & discount....then, it churns out the extended price.

So far so good.

I changed the SQL expression for the view so that the where statement says the following:

WHERE ordersdetail.norderid = ?m.varnorderid

I through in a variable, per your advice, so that I didn't use the exact field name. That way I will not have problems down the road when I want to use the view again!

Now, I need to take this view and call it up in my form.
In the form designer for my orders entry form I have called up my data environment and placed the following tables into the environment:

Customers (table)
Orders (table)
extended_price_detail (parameterized view)

this is where I begin to get lost -- The ability to Refresh/ReQuery.


I need to write the following code each place a parent record changes>

lnParentID=ParentTable.PK
REQUERY('MyChildView')
THISFORM.ChildGrid.Refresh()

This code translates into:

m.varnorderid = orders.norderid
REQUERY("extended_price_detail")
THISFORM.extended_price_detail.Refresh()

However, I do not know where in the properties box I need to write this expression for each change in the parent.

For example, each time I select a new customer, the address, ordernumber, shipper info, required delivery date, order date, etc. changes to reflect the new information. This is where I need to use that expression?

Plus, I need to put some code in the buttonset, for when I go to a new record, but I do not know what?

I would certainly appreciate any feedback you could give me to proceed further with this form.

Thanks in advance Erik
Jason