Relationship Issue
For this question I have 3 Tables: Associates, Travel and Oracle. What I need to do is the following. The Associates to Travel is fully functional, so I have travel going to City ABC and X,Y,Z associa...
Forum Discussion
Finally able to get back to this; the other part of work got in the way...
Master Table - Associates is connected to the Details Table - Travel.
EmpID is common denominator
Embedded report that provides me with all the travel an associate has made... so I know this is good to go.
Master Table - Associates is connected to the Details Table - Oracle.
EmpID is once again the common denominator.
Embedded report that provides me with all the time punches an associate has made... so I know this is good to go.
What I can't seem to figure out is how to get the three tables to really talking to one another in order to provide the reporting that is necessary.
The "Time" is the "Oracle" table
I can do this in Excel with this formula; =SUMPRODUCT((Time!EmpID=Travel!EmpID)*(Time!ElementName=Travel!ElementName)*(Time!Date>=Travel!Date)*(Time!Date<=Travel!Date),Time!Hours).
But for the life of me I cannot get it to work in QB
Master Table - Associates is connected to the Details Table - Travel.
EmpID is common denominator
Embedded report that provides me with all the travel an associate has made... so I know this is good to go.
Master Table - Associates is connected to the Details Table - Oracle.
EmpID is once again the common denominator.
Embedded report that provides me with all the time punches an associate has made... so I know this is good to go.
What I can't seem to figure out is how to get the three tables to really talking to one another in order to provide the reporting that is necessary.
The "Time" is the "Oracle" table
I can do this in Excel with this formula; =SUMPRODUCT((Time!EmpID=Travel!EmpID)*(Time!ElementName=Travel!ElementName)*(Time!Date>=Travel!Date)*(Time!Date<=Travel!Date),Time!Hours).
But for the life of me I cannot get it to work in QB