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
This is going to be tricky for several reasons;
1- It has to be data specific, so it applies to the appropriate "Reset".
Does the Oracle report have day to day reporting, every punch, or just a summary?
(Each Reset --> (has many) Oracle Entries)
2- It also has to be specific the the Employee ID.
Which can be related to the associate no problem, and might even be automatic if your key field is the ID, but trying to tag those Oracle lines to the travel also presents a few problems, as it has to be conditional on "ID" AND "Date" AND (possibly) a "Reset".
Does the Oracle report have the "Reset" listed? Is there a Unique ID for the Reset as well.
( each Associate --> Oracle Entries)
3- if you can create some concatenated field on the "Travel" table, you could say each "Travel --> Oracle Entries". Then make that connection conditional, but this would still be a manual process.
(i.e. Combine Associate ID and travel Date, to compare to a similar field on the Oracle table)
Basically you will connect the Oracle table as a child to all 3 tables, however making the connection automatic greatly depends on your data. It might require some type of script to connect it all the right way.
1- It has to be data specific, so it applies to the appropriate "Reset".
Does the Oracle report have day to day reporting, every punch, or just a summary?
(Each Reset --> (has many) Oracle Entries)
2- It also has to be specific the the Employee ID.
Which can be related to the associate no problem, and might even be automatic if your key field is the ID, but trying to tag those Oracle lines to the travel also presents a few problems, as it has to be conditional on "ID" AND "Date" AND (possibly) a "Reset".
Does the Oracle report have the "Reset" listed? Is there a Unique ID for the Reset as well.
( each Associate --> Oracle Entries)
3- if you can create some concatenated field on the "Travel" table, you could say each "Travel --> Oracle Entries". Then make that connection conditional, but this would still be a manual process.
(i.e. Combine Associate ID and travel Date, to compare to a similar field on the Oracle table)
Basically you will connect the Oracle table as a child to all 3 tables, however making the connection automatic greatly depends on your data. It might require some type of script to connect it all the right way.