I have Table 1 that contains unique links to multiple tables;Table A, Table B, Table C. Each of Tables A, B and C track various types of activities. I am trying to create a query that would provide a chronological listing of all activities regardless of what type of activity. Each of Table A, B, and C contain date/time stamps.
One way is to have a field that would pull the date/time stamps from each of Tables A, B and C and present one date/time list of which I could sort chronologically. Is there a way to do this or is there an alternate way to accomplish my goal.