Hi Erik - It is alwasy nice receiving your replys. First of all, thanks for the tip concerning the naming convention of my expression field. I believe when I typed it in, FoxPro converted it to Extended_Price, but I could be wrong. I will check when I get home.

I would like to talk for a minute about the proceedure you recommended to me concerning the creation of a "parameterized view". Needless to say, this is the first time I have heard of that type of view, so I didn't fully understand everything you mentioned.

Let me see if I follow what you are saying, b/c I believe this is very important and would like to comprehend this proceedure.

I created a "regular" view with the tables, ordersdetail and products, which produced the desired results I was looking for. The view access teh information located in the ordersdetail table and computes the expression I created: (unit$ * quantity) - discount.....

What your saying is I need to call up that view I created and select
CREATE SQL View.... which I believe is an option on the left side of the view designer.

The expression you gave me, CREATE SQL View extended_orders_detail AS SELECT *FROM ordersdetail WHERE ordersdetail.FK = ?order.norderid

Note: "order" is the name of my parent table]

That expression above is the "tie", which enables the parameterized view to work in conjuction with my parent table, correct.

(1) Where do I type this expression? In the view designer?



The next step you layed out was to change the records in the parent table.
I don't have any records in there at this time. I may not be understanding what you are saying here, regarding changing records in the parent table. My parent table is "orders", which as of right now is empty.

Then, you said to set the lnParentID (which is "norderid") to the pk of the parent table.

(2) Do I do this in the properties window when I get to the form designer, or can I do this in the View Designer?

(3) Where does the REQUERY()go?

Please forgive me if some of these questions seem super simple. I am not sitting at my computer with the application, so I can't look at the view or form designer to see if some of these questions are self evident.

Thanks for any help Erik

Jason