Moreover to effectivily use data on tables that are joined you must state the cardinality. Bobj can get it wrong sometimes so I'd advise you to set them up manually.
Cardinality expresses the minimum and maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0, 1, or N. Because a join represents a bidirectional relationship, it must always have two cardinalities. If you selected the Detect cardinalities in joins options in the Database tab of the Options dialog box, Designer detects and retrieves the cardinalities of the joins. If you do not use this option, you can still retrieve the cardinalities for one or all joins in the universe. There are two main methods for detecting or editing cardinalities: the Detect Cardinalities command the Edit Join dialog box
