N
Nestor
I had created a database. In the database I have a couple
of tables. The table (table1) with 5 records and about 3
fields each (name, Department, class). Second table
(Table2) is for information storage. I am using a list box
to display the information from table1 in a form. What I
would like to do is to select a record from the table1 in
the list box and have these records populate three fields
in the form that belong to table2. How do I do this?
Please advise. Thank you in advance for your help!
Example
When selecting the following record from the list box
List
Nestor|MIS|MCSE
Will populate
Name : Nestor
Dept: MIS
Class: MCSE
of tables. The table (table1) with 5 records and about 3
fields each (name, Department, class). Second table
(Table2) is for information storage. I am using a list box
to display the information from table1 in a form. What I
would like to do is to select a record from the table1 in
the list box and have these records populate three fields
in the form that belong to table2. How do I do this?
Please advise. Thank you in advance for your help!
Example
When selecting the following record from the list box
List
Nestor|MIS|MCSE
Will populate
Name : Nestor
Dept: MIS
Class: MCSE