I need to create a report where data will come from a main table and two additional tables that have a many-to-one relationship with the main table. This is easy to do with only one Many table involved, but with two (or more) I'm looking for an easier way to do it than doing a bunch of processing of the data.
Is there a SQL command or View that can be established to make this easy?
Patrick
6.5++ Windows 1.864xRT03
Example:
Client Information
Client's Children
Client's Organizations

