Getting a command button to open multiple forms

[Novice]

I am develping my first database and probably breaking
every rule of logic.

The mess I'm creating has a School Population form that
has a combo box referencing a union query that combines
students and teachers names.

Both Student and Teachers have their own form with
specific data for each.

Is there a way to put a command button on the School
Population form that will go either to the Student Form or
Teacher Form that references the individual in the combo
box?

I know you experts are scratching your head and giving a
light chuckle, but I'm learning through trial and error.
Believe me, I'm learning a lot. Mostly what not to do.

Thanks

 

[Adrian Jansen]

Get your data structure ( the tables and relationships ) right, and THEN
start developing queries and forms. What you want is trivial with a proper
design. Read up on normalisation in the help, and elsewhere.

Rather than union two tables, all persons should be in one table, with a
type field to identify Teachers or Students. Then its easy to present the
Teachers or Students separately, just by filtering for one or the other, or
both combined, just by not filtering.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Byron]

Could you provide a little more info? Exactly what
information is in your combo box? You seem to indicate
that both Teachers and Studenst can be selected from one
combo box.

If you can provide a little more information perhaps we
can help.

Byron

 

[Guest]

I'm a bit confused about this.

Yes, the combo box lists both students and teachers. I
created the union query from the students table and
teachers table. Each has its own form, but they both
refer to a common one too.

The common form has the combo box. I have a command
button that I want to have go to the form specific to the
individual in the box. Sometimes it will be to the
teacher's form and other times it could be the student
form.

I thought this was normalized since there is no
duplication of data. Both students and teachers have
specific data for each. Putting them on a common table
just doesn't seem right.