ajaymansata
Registered User.
- Local time
- Today, 22:21
- Joined
- Dec 17, 2001
- Messages
- 25
Hi
Well i have a search from.Say i enter the last name as the search criteria.
Now i have some tables called personaltable,edu table,employment table.
All the tables are linked with a common field studid.
Now i have created a form which has personal table in the main form and subforms based on the other two tables.
Now when last name is entered as a search criteria i want the following things to be done
It should retrieve all records from personal table and display it in a form.
Secondly when the user clicks or moves from on record to another another form showing complete details from the other two tables should also be displayed.
That is both the froms should be synchronized.
Can someone please tell me how can i achieve this.
thank you.
Well i have a search from.Say i enter the last name as the search criteria.
Now i have some tables called personaltable,edu table,employment table.
All the tables are linked with a common field studid.
Now i have created a form which has personal table in the main form and subforms based on the other two tables.
Now when last name is entered as a search criteria i want the following things to be done
It should retrieve all records from personal table and display it in a form.
Secondly when the user clicks or moves from on record to another another form showing complete details from the other two tables should also be displayed.
That is both the froms should be synchronized.
Can someone please tell me how can i achieve this.
thank you.
