G
Gargamil
Here's the scenario,
* I have a local table that is being kept up to date via a query. This
local table is a subset of a linked server table.
* From this subset I want to define a sub-subset that I will use for a
specific set task.
Now, there is no rhyme and reason for selecting the given records - at least
nothing that can be coded. So I considered adding a Yes/No box to the
subset table and ticking which ones were required. The problem with this is
that it would prevent me updating the rest of the fields in each record
through a simple query. The only other option I can see is to create a
parallel table containing the record identifier and a Yes/No box to record
the sub-subset and use this table to define what I can select at run time.
This allows me to delete / re-create the local table at will and still keep
all my flags.
Or is there a better way??
g
* I have a local table that is being kept up to date via a query. This
local table is a subset of a linked server table.
* From this subset I want to define a sub-subset that I will use for a
specific set task.
Now, there is no rhyme and reason for selecting the given records - at least
nothing that can be coded. So I considered adding a Yes/No box to the
subset table and ticking which ones were required. The problem with this is
that it would prevent me updating the rest of the fields in each record
through a simple query. The only other option I can see is to create a
parallel table containing the record identifier and a Yes/No box to record
the sub-subset and use this table to define what I can select at run time.
This allows me to delete / re-create the local table at will and still keep
all my flags.
Or is there a better way??
g