I have reached a bit of an impasse on quite a specific design aspect and wonder if anyone has any tips.
I have a large table which is linked to a separate database and is therefore not editable.
From this table, I have created a query to identify a subset of rows from the larger set.
What I want to be able to do is now add a new column to the data that is in the query, but which is based on a lookup in another table.
I cannot add the column with the lookup values to the query, so I have tried to use the make table option to create a new table, but then I have to manually add the lookup column.
Can anyone think of a method which creates a subset of a larger table, but then adds a column which allows the user to select from a drop down values based in another table, without a manual intervention?