>Hi All,
> How to display data when i searching from fields?
>I define 2 DBF that..
> Member(Code_ID,Code_UL,Code_DD) by Code_ID is a Primary Key
> Data_Mem (Code_ID,Name,Address,Tel) by Code_ID is a Primary,too.
>(By...Data of Member.Code_ID can't equal with Member.Code_UL but Member.Code_UL can equal with Member.Code_DD,And data of Member.Code_ID or Member.Code_UL or Member.Code_DD can equal
>with Data_Mem.Code_ID).
>
>** This Exam of Member's data **
>Code_ID Code_UL Code_DD
>1205628 0954595 0954595
>0120105 1205628 0954595
>3333333 1205628 0954595
>1230455 3333333 0954595
>
>So,When I search Code_ID from Member(If found),I will keep Code_UL to search in Data_Mem for display fields Code_ID and Name. If Code_UL is duplicate ,I will searching and display continue untill not found.
>
>How to display every Data for found searching in a Grid?
>
>Thank you for suggest.
>
>Pongthap.
Hi
If you create a parameterized view and place this in your form, you just have to REQUERY() the view each time you want to see data for another Code_ID.
Benn Kjaer
MS Certified Professional - Visual Foxpro
"There is something rotten in the state of Denmark"
"Why make user-friendly programs, when there aren’t any friendly users :o)"