Hey everybody, a question I hope someone can answer...
I have a table (well a few tables) with composite primary keys (upto 4 fields). I am using the Recordset method for interacting with the data held within, and was wondering if it was possible to search on composite primary keys using the seek or find (I prefer using dynasets) to locate specific records - primarily to check whether records already exist or not, and then either update or add new entries as neccessary.
So, in summary is it possible to use the seek and find on composite keys, or will it be a convoluted case of nesting the find statements. And looping until the specific record is located (or not as the case may be?)
I have a table (well a few tables) with composite primary keys (upto 4 fields). I am using the Recordset method for interacting with the data held within, and was wondering if it was possible to search on composite primary keys using the seek or find (I prefer using dynasets) to locate specific records - primarily to check whether records already exist or not, and then either update or add new entries as neccessary.
So, in summary is it possible to use the seek and find on composite keys, or will it be a convoluted case of nesting the find statements. And looping until the specific record is located (or not as the case may be?)
