Hello Erik -
I apologize for asking so many questions about this one topic, but if I don't ask questions, my chances of completing this form successfully are slim!
Last night I worked on the SQL statement and modified it in the command window, then overwrote the existing SQL. I "think" I was successful, but I want to make sure. After I completed the SQL statement and "browsed" the view, a form popped up that asked me for a parameter, and didn't show me the records in my orders detail table as it had before.
So, I wanted to show you my WHERE statment in my SQL statment to make sure everything was ok.
I understood your SQL statement, minus the last part.
You wrote:
SELECT*
FROM Child table
WHERE Child table.pk = ?lnParentID
So, I went in and changed the SQL statement for my view to:
WHERE ordersdetail.norderid = ?orders.norderid
Quick background:
Orders is primary table
ordersdetail and products tables were used to create my view, which is called exxtended_price_detail
Orders table is linked to ordersdetail (norderid) in a one to many relationship
orders detail is linked to products (nproductid) in a one to many relationship
My question is> Is ?orders.norderid what you were referring to in your lnParentID?
That was the part I was a little confused. The reason being, later in your post, you stated that wherever there are changes in the parent record, to issue the following changes:
lnParentID = ParentTable.pk
REQUERY(extended_price_detail)
THISFORM.extended_price_detail.Refresh()
If this is the case, lnParentID = ParentTable.pk would be:
orders.nordeid = orders.norderid
*** Point being, I just want to make sure I am passing the correct parameter in the WHERE statement.
Last night I read in my programmers guide book that in a scenario where a list box and grid are being set up in a one to many relationship, you need to set up a parameterized view. It said to throw a variable into the selection criterion, so that it read, ?m.Cust_id (at least that is what it used in the example).
I noticed it threw in that ?m.
I was just wondering if that is what you meant with ?lnParentID, that I needed to throw in a variable?
Do I have things set up correctly, or am I missing the boat?
Thanks for your time Erik, I truly appreciate it.
Jason
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