At 00:50 07.09.2000 -0000, Dave Bishop wrote:

>I don't know if this is the correct forum for my question, but I am a
>desperate man. I would appreciate any help.

I guess that one of the mailing lists or newsgroups found at www.mers.com
would be more appropriate and helpful. I think you'll find more skilled
programmers at those lists.

>am not sure if the BDE uses primary keys internally to resolve

The only tip I can give you is to get rid of the BDE dependency. It's the
worst of three alternatives. IBX comes free with Delphi 5 Enterprise (and
possibly Professional, I don't know), and I think it should work far better
than the BDE if you get the latest upgrades (though I've never tried it).
Myself I use the third alternative: IBO (www.ibobjects.com) deservedly won
the Best Database Connectivity Award from Delphi Informant this year and
makes it simple to convert a BDE-based application to IBO (Jason Wharton
converted an application in less than one second, and says most
applications should be possible to convert in less than 10 minutes). It may
cost you a few hundred dollars though, if you're using it for commercial
applications.

For a comparison of the BDE, IBX and IBO, take a look at
http://www.interbase2000.org/WhitePaper/Connectivity.htm

Set