>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.

did u try candidate keys?

Arnon