Best way to view table data on subform?

[aladinabox]

Hi,

I'm just wondering if someone could point me in the right direction with this: I have a table that holds "course codes" with the corresponding Module title and module codes, and assessment titles and codes that are used in each of the courses, so I have a few records that will go against one course code. I have forms set up with subforms, with the same general details on the top of each as the main details, and each of the subforms giving different information. But, for four of my subforms, I need to pull information from this table with the module title, module codes, assessment title and codes. Could someone tell me firstly is this possible to have these certain columns appear across four subforms, and what is the best way to go about it, I was thinking of using lookups?

Thanks for your time.

 

[Pat Hartman]

If you have common fields, they probably belong in a different table. You would then bind the main form to the "parent" table and show the "child" data in a continuous or datasheet subform.

You have a lot more flexibility with formatting for reports. Forms should be optimized for data entry and quick lookups. Use reports when how data is displayed is more important.