Barbara,

Thank you so much for your suggestions. I understand clearly what you're saying here. I just got finished trying it all out and it's working beautifully. You've given me something to work with for a few days now. Thanks again. You and the others here at UT have been so helpful in my learning VFP.

Sincerely

Elgin Rogers
Epic Solutions

>Elgin,
>A lot of questions :-)
>
>First, before you try any of this, read the information "Creating Views" in the manual (Chapter 8) or in the HELP. Particularly look at the section on "Parameterized Views". Design one or two simple parameterized views and test them in the View Designer with the RUN button.
>
>>Barbara,
>>
>>How can I use the Requery() function without having the user enter the information twice. Do I setup something like a procedure called "getit"? And maybe DO Getit WITH "Parameters".
>
>Requery() - If you are using parameterized views, you set the parameter property to the required value and then run ReQuery(). If you have a view v_customer with a parameter cCustID:
>
>cCustID = '12345'
>Requery('v_customer')
>
>This would go in your code whenever you wanted to update that data.
>
>
>>And what if I'd like to find one particular CUSTID in the Parent table and then zero in on one particular record (UPSI_NUM)in the Child table. I would like to ask the user two questions:
>>
>>Parent: What CUSTID? and Child: What UPSI_NUM? then have it find the CUSTID on my form then the UPSI_NUM in my grid that's on my pageframe.
>
>If you are using parameterized views, then you simply get the required parameters from the user and run the requery() on each view.
>
>
>>You said I can index the child View just like any other table. Can I also use the Set Relation command between two views in the Dataenvironment of my form?
>
>You can't call Set Relation unless the child table is indexed. If you want to load the views in the DE, then in your INIT you can run the indexes you need and set the relations programmatically.
>
>Or do it all in the LOAD() function or the DE OpenTables() function. Be sure you call DoDefault() before adding your own code. My preference is to use the LOAD() function. If your data is opened there then all your controls will be able to see it as they are initialized, and you won't have any trouble with setting controlsource, rowsource, etc. properties.
>
>
>>Thank you for the help. It is much appreciated.
>>
>>Elgin
>
>No problem. Hope this gets you started.
>
>Barbara