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.
Précédent
Suivant
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