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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement