Subject RE: [IBO] TIB_LookupCombo - Join Tables - too ambitious??
Author Helen Borrie
At 03:46 AM 17-09-02 +0200, you wrote:
> >It's impossible to guess what you're actually trying to achieve here, but
> >what you are doing is not logically achievable.
>As you may recall,
> >My intention is to allow a user to add to the COVEREDMEM table from within
> >TIB_Grid. when the user enters an 'ID' in the Person's ID column, the
> >associated TIB_LookupCombo control must drop down and do an incremental
> >search for this ID(not PersonId - which is a gen value). If the value is
> >matched, and the user... from here I believe I can handle the various.
>Maybe I should explain again. All I want to use this TIB_LookupCombo for, is
>to do an incremental search for this person in the person table, and if
>found, insert the associated PERSONID of the Person Table into the PersonId
>Field of the inserted record in the CoveredMem table. If not found(via the
>NotInList event), then insert a new record into the Person table and add
>this PersonId to CoveredMem.PersonId. I have the Person tables fields
>editable because of the InsertSQL. This is all to be done via a TIB_Grid.

I don't have any more time to throw at your problem. I've said that what
you are doing isn't logically possible because of the three simultaneous
"hits" on the same record in your Person table. You need to remodel this
so it works at a logical level: from that point, it will then be possible
to implement it in a way that works physically.

When I get myself into a bind like this, I sit down with pencil and paper
and draw the model. It's always more productive than ripping out my hair.