Access 2002 Programming by Example

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