Query in preparation for tabbed form

[Guest]

A School information database. I have a Table "students" PK StudentID and 4
other secondary tables with "Students" as a child key in each - all linked to
Students 1 - many (CK Students). The first 2 tables work fine but when I
enter the 3rd table, the data i the successful query disappears and the form
has nothing on it ...
All tables have the PK Student with sql dropdown to show the student's name.
No other secondary ID fields are present. HELP
please ....
Thank you

 

[John W. Vinson]

A School information database. I have a Table "students" PK StudentID and 4
other secondary tables with "Students" as a child key in each - all linked to
Students 1 - many (CK Students). The first 2 tables work fine but when I
enter the 3rd table, the data i the successful query disappears and the form
has nothing on it ...
All tables have the PK Student with sql dropdown to show the student's name.
No other secondary ID fields are present. HELP
please ....
Thank you

Don't try to make One Great Master Query to do everything.

Instead, use a Form based on Students, with four Subforms, one based on each
of your related tables. Use the StudentID as the master/child link field.

John W. Vinson [MVP]

 

[Guest]

Don't try to make One Great Master Query to do everything.

Instead, use a Form based on Students, with four Subforms, one based on each
of your related tables. Use the StudentID as the master/child link field.

John W. Vinson [MVP]

Thank you foryour response. How can I then turn these subforms into a series
of Tabbed pages? My Microsoft reseach led me to believe that the only way to
achieve this is via a query.

 

[John W. Vinson]

Thank you foryour response. How can I then turn these subforms into a series
of Tabbed pages? My Microsoft reseach led me to believe that the only way to
achieve this is via a query.

A Tab Control is just a tool to let you share screen real estate.

You can create a Tab Control and put a Subform control on each page of that
control (or you can put two subforms, or a subform and half a dozen other
controls, as needed).

I have no idea what led you to the conclusion that Queries have anything to do
(directly) with tab controls...

John W. Vinson [MVP]