Fill-up Data automatically

I have two tables
School (sch_id, sch_name, type, cluster, address, phone)
Teacher (tch_id, name, designation, sex, birth_date, join_date, education,
sch_id, sch_name, type, cluster)
I want when i type sch_id in Teacher table Access fill up sch_name, type,
cluster from School table automatically.
Pls help.

--
binary romel

No, you don't. REALLY, you don't!

Access is a relational database. There's no need to duplicate the
[sch_name] and other data in multiple tables.

You might take that approach if you were using a spreadsheet, but Access is
NOT a spreadsheet.

A common reason why folks believe they need to duplicate data between tables
is because they are trying to create a table that they would then use for
reporting. Don't!

A well-normalized relational table design stores data about Schools in one
table, data about Teachers in another, and uses a third table to show which
[Teacher]s are associated with which [School]s. Then you use a query to
join these together and base your report on the query.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"binary romel" wrote in message
...
I have two tables
School (sch_id, sch_name, type, cluster, address, phone)
Teacher (tch_id, name, designation, sex, birth_date, join_date, education,
sch_id, sch_name, type, cluster)
I want when i type sch_id in Teacher table Access fill up sch_name, type,
cluster from School table automatically.
Pls help.

--
binary romel