>I have four DBFs: MASTER, TableA, TableB, TableC.
>
>MASTER.field1 is related into TableA
>MASTER.field2 is related into TableB
>MASTER.field3 is related into TableC
>
>The MASTER-to-TableA relationship is One-to-Many.
>The MASTER-to-TableB relationship is Many-to-One and
> MASTER must be the parent.
>The MASTER-to-TableC relationship is Many-to-One and
> MASTER must be the parent.
>
>How the heck do I make this happen with the Database
>Designer if MASTER can only have one Primary Key?!?!?!?
>It seems that I can only create relations on primary
>Keys.
John
Yeah, like Arnon says, use candidate. Try not to use Unique. Use Primary indexes only if you have to. Primary indexes are stored in the DBC & then you hooked into physical links to the headers & DBC.
Tom