I have a Table that records 3 actions per record that use a linked table for the detailed description reasons of the actions.
The tables have the following fields and data:
A table recording the actions [Actions] using an action description ID:
ID Action_A Action_B Action_C 1 1 1 2 2 2 2 1 3 3 3 3
And the table describing the actions [Actions_Description] as:
Action_ID Description 1 Walk 2 Run 3 Jump
Now I wish to create a Report that displays the results as follows:
ID Action A Action B Action C 1 Walk Walk Run 2 Run Run Walk 3 Jump Jump Jump
In both tables the ID field is the primary key.
How do I construct the select query that with be used as the data source for the Report?
The conundrum that I have is that [Actions_Description].[ID] needs to be linked to each of the [Actions].[Action_A], [Actions].[Action_B] and [Actions].[Action_C] fields and I've been unable to work out how to create a query do this.
Scratching my head...