• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Taking Charge of Reports > Using Table Relationships to Include or ...

Using Table Relationships to Include or Preclude Entire Sections of Report Data

You have already seen how relationships can provide an effective way to look up data in a form. If you have data that must be conditionally entered into a report, depending on values in a field, table relationships can be an invaluable tool to help you accomplish that goal. If you think of the one side of the relationship as the parent table and the many side as the child table, the technique you are about to see reverses this. The parent table functions as the many side of the relationship, and the child tables function as the one side. However, the goal is the same: to minimize redundant data. The conditional technique is an extra benefit that is often overlooked.

Before getting into the mechanics of this technique, there is another database function that is often overlooked. Although some might argue this point, databases have a definite advantage over spreadsheets, and even word processors, when it comes to preprinted forms. It seems that no matter where you go in the business world, you have to fill out some kind of form. Perhaps you are applying for a credit card or leasing an apartment. If you want to be able to track this information for sorting, calculating, and retrieval purposes, a database is your answer. The report isn’t limited to outputting to a preprinted form because it can print the entire form, if necessary.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint