Hi Jim! I took your class in December in N.Carolina.......and what a wonderful class it was! I don't see you very often of UT, so I jumped at the chance to write a question.

I sure hope you can help me with this.

I created a view for my orders table, to place it into the orders form as a grid. I used my "ordersdetail" table and "products" table, to query the desired fields I need to make it work. I accomplished that just fine. I called this view:

extended_price_details


From talking with developers on Universal Thread today, I learned I needed to create a parameterized view to accomplish this task, in order that the grid is refreshed each time the user goes to a new recrod.

so, I went to the command window and changed the SQL statement so that the WHERE statement said:

ordersdetail.norderid = ?orders.norderid

this way, the child record (ordersdetail) takes the pk of the parent table as a parameter. So far so good.

I overwrote the SQL code to reflect this change.

Now, I want to go back to my form and place this in there and make it work, but have not been successful.

Even with the help of the developers today, I have been struggling to achieve this b/c my programming experience is miniscule!

I need to requery the view, but am not quite sure how to do it.

Ultimately, I want to be able to select a customers name in a combo box and have the grid reflect that person's address, phone, etc., as weel as have the grid I created as a view (extended_price_detail) updated to reflect the products they owe.

(1) Where do I place the requery command
(2) I was given this code today:

lnParentID=ParentTable.PK
REQUERY("extended_price_detail")
THISFORM.extended_price_detail.Refresh()

I understand the last two statements, but the first line is unclear to me. Should that be:
nordersID = orders.nordersid

I now this is long and I am confusing myself just typing it, so I will stop. If you have any direction as to how to proceede when I go to the form designer and place the "view" and orders table into the data environment, I would sure like to hear your thoughts.


As for any reading this>

Jim is a great teacher!!!!!!

nice plug, huh, jim!

Jason