Very Computer

Please forgive my questions if they are silly - but answer them anyway if
you can.

Quote:> I am rather new to programming and  have a Delphi 3 application with a
> Master/Detail Table relationship. In the Master only one field is keyed and
> in the Detail two fields are keyed. No Autoincrement fields are used. When I
> try to edit one of the Keyed fields I keep getting (oh Boy am I tired of it)
> the Record/Key Deleted message. Have been trying to trap the error but am
> not succeding (maybe I should look for another occupation instead?).  The
> same application written in Delphi 1 runs just fine (urrgh).
> Would be very thankful if somebody out there has any ideas on how to solve
> this problem.

How does delphi know about your relationship?  Are we talking about two
ttables with a MasterSource style relationship?  I find it hard to
believe that something this simple is causing the BDE problems.

The simple solution would be to not show the keyed field that is common
to both.  If the user is too change this field, then you will need to do
a DisableControls, allow them to change the field, do a Refresh, and
then do an EnableControls.  This sort of operation might be described as
a 'move'.

Have done a disable/refresh/enable and it works fine now.

Will certainly post more questions, knowing me:-)

Actually - assume we have a MasterTable and a DetailTable. In the
MasterTable are say Customers, in the DetailTable Orders. The MasterTable
has only one Keyed Field, say Customer Number, and the DetailTable has two
CustomerNumber and InvoiceNumber or DateOfPurchase. Assuming that there are
entries in the DetailTable, after a while the enduser discovers that the
wrong CustomerNumber
has been used for a while. If the CustomerNumber is edited in the
MasterTable the Details have nowhere to belong to. My question is how do I
Update all CustomerNumbers in the DetailTable as they are edited in the
MasterTable?

Well, that's all (I hope)