1 Reply Latest reply on Mar 20, 2012 2:48 PM by philmodjunk

    Combining Fields from two different related databases in columnar report

    ingridblaauw

      Title

      Combining Fields from two different related databases in columnar report

      Post

      I have two status databases: one for US Matters, one for Foreign Matters.  Both share a common Client Number field.  I'd like to created a report based on a find by client number, sorted by Matter Number (unique matter identifiers in each of the two status databases).  So if I have one US Matter (T001) from the US database, and five Foreign Matters (T001JP, for example) from the foreign database, and then US Matter T002 and three foreign matters (T002US, etc.), the report would sort and display all matters from both related databases, with page breaks as needed.  Is this do-able?

       

      Thanks in advance for any advice you can give.  I'd love to combine both databases into one, but that is not an option.