O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required