Hello,

> You can use generators to do some things.
> You can share a generator with some tables, but you need to respect
> generator value limit (2.147.483.647).

Yes, I thought about that. I use Int64 for all primary Indexes.

> If you use the Master.PK as Detail.PK, you can have only one Detail
> record for each Master record (Relation One To One). If you want to
> do this, it's Ok. But if you want relation One to Many, you need to
> use another field to be your Detail.PK.

No, that's a misunderstanding. The detail tables have their own
(integer) primary keys, but they use the primary key of the master
table as reference in the second column. It's allways an one to many
relation.


Thanks for your help.

Regards - Ulrich