Hi,

I have the following tables

Person
------
PersonId ID Firstname Surname

Member
------
MemberId Firstname Surname

CoveredMem
----------
MemberId PersonId OptionId FundId

I use qryCoveredFamMem to add Covered members to the CoveredMem table.
qryCoveredFamMem is a join of CoveredMem and Person - Fields are a combo of
both tables.

I need to display a drop down of the person table with the ID field as the
lookup field, but the field to be inserted into the CoveredMem table must be
PersonId, not the ID field. In other words, I want to do an incremental
search on the Lookup dataset on the ID field, but store the PersonId field.

Currently I have the KeyLinks in the qryPersonLK(the lookup query) set to
Person.PersonId=CoveredMem.PersonId and the Display field of the
TIB_LookupCombo = ID.

Are my intentions possible?

Thanks,
Dion.



-----Original Message-----
From: Dion Oliphant [mailto:dion@...]
Sent: Wednesday, September 11, 2002 11:36 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] TIB_LookupCombo


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.

Thanks,
Dion.





___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/