2 subforms and filtering data

[abenitez77]

I have a form with 2 subforms.

When i move from record to record on subform1, I want subform 2 to filter on the key.

I currently have code running on the "On Current" that creates a table for subform2, but it does not filter the results by the current record we are on in subform1.

How can i do this?

 

[bborissov]

And how this questions in SQL Server related?
What is your front end language?
If you know that ask in its forum )

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[abenitez77]

sorry..i put it in th wrong place...