OK.  I have an Image database (actually, a bunch of 'em) that I would
     like to access through ODBC and Micro$oft Access.  The ODBC drivers
     are from MB Foster (ODBCLink).  The Image database has five sets.  The
     master set contains a whole bunch of data on employees, with SS# as
     key.  One of the detail sets (salary history) has multiple records per
     person, sorted by a YYMM type date field.  This is the data set that
     is causing me grief.  Y'see, Access requires a unique key in order to
     have write access to a table, and I can't see an easy way of telling
     Access to use the combination of SS# & YYMM as key.  Because the set
     has no unique key, and write access is specified, Access basically
     goes bananas and returns the wrong number of records, with incorrect
     data.
 
     All right, so here's what I'm thinking, if you want to call it that.
     Maybe I can add a field to the Image database, which is a
     concatenation of SS# and YYMM, and tell Access that this thing is the
     data set's key.  Before I go much further down this path, could
     somebody please tell me (1) what's wrong with this picture, and (2)
     what the right thing to do is?
 
     Thanks very much.
 
     Bob Brown