I have a form that has two FP 2.6 tables related on the CUSTID field as the Dataenvironment.

This form also has a container "cntSearch" with a textbox. Initially the container is NOT visible. I have a Search button to make the container visible. I would like the user to be able to type a new CUSTID in this container's textbox and when the container loses focus set the Filter property of Cursor1 to the value typed in the text box. Or even have multiple text boxes in this container to set the Filter on any or all of the Cursors in this dataenvironment.

I know I should probably be doing this with Views in the Dataenvironment, but I do not understand how to relate two views in the Dataenvironment. Remember the underlying tables are FP 2.6 tables and I cannot change there format to be part of a VFP database. The relationship between the two tables has to be a One-To-Many.

The performance of the form is working well as it is now with the Tables being the Dataenvironment, but I need to be able to Filter by CUSTID and sometimes other fields in addition to CUSTID.

Thanks for your help. Thank God for the Pros.

Elgin

Epic Solutions.