I have an application which creates records based on a control counter
(courtesy of some fine advice on DUG). To create new records the
datasource for a table includes an 'OnStateChange' handler which reads,
increments and saves a counter back to a control file, and uses that
count as the key for the record.
I need to expand the system to handle data from multiple sites. Since
two sites will have different master records with the same ID I figure
on enlarging the key so that each site has a unique ID, and the key
value for each record would thus be a composite of the existing counter
and the Site ID.
I dont know how to configure this using database desktop.
Can someone please enlighten me on the sanity of this solution and best
way to achieve this? Alternatively I will have to confine the ranges if
IDs to be unique at each site.
I think I need to change the primary key in the master file, and the
reference pointer in the detail file. I have;
MASTER ======= DETAIL
ID (I*) <----- ID
|______owner (I)
I want;
MASTER ======= DETAIL
SITE(A1*) <| ID
ID (I*) <|
|______owner (?)
regards
Leo Ramakers
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
