akrishmohan
Programmer
Hi someone please help me with this problem with access database...
i have two tables named PITable and Datatable.
the PITable consists of two fields last name and firstname ..the combination of which is a primary key.It forms a one-to-many relationship with Datatable wherein
there are 20 fields out of which two of them are lastname and firstname.
now i design a form whose recordsource is PITable,place a combo box on that and populate it with the lastname and firstname under two columns.
i have a subform in the form whose record source is Datatable.Now i would want to search by the last name...if more than one last name occurs i would like search with a combination of last and first name.What i mean is for a given last and first name in the combo box(which is unique) i shud be able to pull up that record info in the subform whose record source is datatable.Please help me with this.
Thanks
Tectonic
i have two tables named PITable and Datatable.
the PITable consists of two fields last name and firstname ..the combination of which is a primary key.It forms a one-to-many relationship with Datatable wherein
there are 20 fields out of which two of them are lastname and firstname.
now i design a form whose recordsource is PITable,place a combo box on that and populate it with the lastname and firstname under two columns.
i have a subform in the form whose record source is Datatable.Now i would want to search by the last name...if more than one last name occurs i would like search with a combination of last and first name.What i mean is for a given last and first name in the combo box(which is unique) i shud be able to pull up that record info in the subform whose record source is datatable.Please help me with this.
Thanks
Tectonic
