4 Replies Latest reply on Apr 1, 2015 1:49 PM by GaoshengHuang

    How can I do something like a union with two tables?

    GaoshengHuang

      Title

      How can I do something like a union with two tables?

      Post

      Hello,

      Could you somebody help out with this issue:

      I have a database with tables Customers, Staff, Appointments, FrontDeskWorkSchedules (please the see relationship in attachment). Basically, there are two kinds of staff: technicians who earns commissions, and receptionists who earn hourly wages. But I need to put their earnings together to form ONE report. How could I do that?

      I would appreciate your ideas!

      Gaosheng

      relationship.PNG