AnsweredAssumed Answered

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

Question asked by GaoshengHuang on Mar 30, 2015
Latest reply on Apr 1, 2015 by 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

Outcomes