Re: [DUG-DB]: how do I use paradox composite keys

[Leo Ramakers]

Tony

> I havent followed this thread, but it is not good practise to use conjugate
> PK's on any database.

Can you say why?

> Master table should have an Integer PK MasterID
> Detail table should have an integer PK DetailID AND a foreign key into
> Master.

This is exactly what I have, but I need to merge a number of databases, each
with the same range of MasterID values. The 'obvious' solution to me was to add
a site ID to the master table, include it in the masterID key, and thereby allow
multiple master and detail tables to be merged.

regards
Leo


---------------------------------------------------------------------------
  New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz