At 11:36 AM 11-09-02 +0200, you wrote:

>Hi,
>
>Is it possible to do a lookup on for eg a surname and have the id of the
>found record placed in the id field of the target table, instead of the
>lookup field(surname). KeyLinks would normally be:-
> lookuptable.lookupfield=targettable.targetfield. So, I would like
> to have
> PersonLookup.ID=CoveredMember.ID for the KeyLinks, but have the
>PersonId field placed in the CoveredMember.PersonId field instead of the
>CoveredMember.ID field.

Not only possible, but essential. Make your Keylinks
PersonLookup.ID=CoveredMember.PersonID and you've got it. (I can't see how
any sort of lookup would work with the Keylinks you have...unless of course
there is a 1:1 relationship between the two tables...)

Helen