Bringing up a table within a form

[internintrouble]

Hello,

I'm fairly new to MS Access and have been feeding off of the in-program help contents. I just recently started my internship at NYSIF for printing, but my supervisor laid a project on my lap that involves using an Access DB to produce an annual shcedule of ORACLE and ARGENT jobs to run.

My Dilemma is that I cannot keep the schedule simple enough without cutting information that needs to be presented.

My question asks:

"Is it possible to bring up multiple tables displayed on a form through using the combo box control(s)".​

My initial idea was to have one form that has interchangable shcedules (tables) for these jobs each month. The table echange would be controlled by the combobox, but the original form would stay the same.

If anyone has any suggestions or what to do or perhaps a tutorial somewheres I happened to overlook, please help me.

Thank You

-InternINTrouble

 

[Rich]

Do some reading on Normalis(Z)ation, you don't need separate tables for each schedule