I'm not sure how to recommend that you do this. I do know that I do not want
to support what you are doing with them. I think it would be too difficult
and complex to figure that all out in code.

I think you should manually do what the KeyLinksDesc does using a
calaculated field or something like that. Perhaps even using the joined in
fields would work well. Then, you could plug in your own EditSQL to handle
all of the columns of the JOIN in a stored procedure and resolve the entire
update in there somehow.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <hugosan@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, July 30, 2001 7:57 AM
Subject: [IBO] TIB_LookupCombo and KeyDescLinks when editing a record


> [ C++Builder 5, IBO 3.6Cf, IB 6.01 ]
>
> I know the "KeyLinks-KeyDescLinks IBO technique" to obtain data from
> another
> table "automatically", and I use it with big result.
> It is much pleasant when, on a Sales system, I need to insert a new
> record
> and, simply typing or searching the Item_Id from a MASTER_PRODUCTS
> table,
> then the Description, Price and Discounts appear, filling almost the
> DETAIL_SALES record (as default values). But then, I should allow to
> modify
> the price or discounts (that which has no problems) and finally post
> the
> record. Well, if re-editing that record, I lose my modified
> price/discounts
> because the KeyLinks-KeyDescLinks act again !
> Can I avoid this behaviour? I find some like "KeyDescLinks only on
> Insert
> mode".
> If it isn't possible automatically, please give me any guideline on
> how
> catch this...
> Thanks in advance,
> Hugo.