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
Matthew,
I was trying to get this "out the door" before I left for the day, so I will try to clarify and address your response.
The process begins with Field Management creating a Reset (this is a job at a specific location, specific date etc...). At some point during the planning phase they will complete the Travel portion (this is where they assign the associates (from the Associates Table) to work the Reset)
At the end of each pay period I receive an Oracle Report, that I want to upload into the table called Oracle. The columns are: Employee ID, this is a distinctive number in the Associates Table, but is not in the Oracle Table. As an associate can have multiple listings each day; clock in, meal out, meal in, clock out etc... Date, Element (type of pay), Hours.
What I would like to achieve is; for the hours from the Oracle Table to "rollup" to the Reset Table - this would have to "pass-through" the travel table as it holds the EmpID's.
The relationship I have are:
Does this help in explaining....?
I was trying to get this "out the door" before I left for the day, so I will try to clarify and address your response.
The process begins with Field Management creating a Reset (this is a job at a specific location, specific date etc...). At some point during the planning phase they will complete the Travel portion (this is where they assign the associates (from the Associates Table) to work the Reset)
At the end of each pay period I receive an Oracle Report, that I want to upload into the table called Oracle. The columns are: Employee ID, this is a distinctive number in the Associates Table, but is not in the Oracle Table. As an associate can have multiple listings each day; clock in, meal out, meal in, clock out etc... Date, Element (type of pay), Hours.
What I would like to achieve is; for the hours from the Oracle Table to "rollup" to the Reset Table - this would have to "pass-through" the travel table as it holds the EmpID's.
The relationship I have are:
Does this help in explaining....?