Stuart McLachlan
stuart at lexacorp.com.pg
Tue Oct 28 22:19:03 CST 2003
On 29 Oct 2003 at 16:46, David Emerson wrote: > AXP adp, SQL2000 > > Currently I have a table of customer primary keys that is filled in from > the contents of a list box. This table is then used to link to other > tables as a filter for processing client records. > > Because the BE is in SQL, the same table is accessed by all > users. However, a user often wants the selection to be maintained between > sessions (ie if they return to the selection screen the next day they want > their previous day's selection still showing.) This excludes temporary > tables (I think) because the users close the program over night. > > If there was a table stored on the local drives then each user could have > their own list of customers. > > What I am unsure of is how I can a) link to the local database to fill it > up with the selections, and b) how I can reference that table within SQL > sprocs which use sql tables. > As an alternative, why not including the users login_name in the table of customer keys, then everyone can have their own selections maintained until they deliberately discard/rebuild them. -- Stuart McLachlan Lexacorp Ltd Application Development, IT Consultancy http://www.lexacorp.com.pg