two active relationships

[SaraAbdulah]

i have 5 tables with one primary key (date), three of them have anther primary key(agentID)

i need help to make the second relationship active 

[AronC]

Hi, I dont get the tables you have. Can you provide a sketch of your model?

I.e. do you have 5 or 8 tables? (You can only have one primary key in one table per definition).

If you which to create a compositekey from two fields just add them togheter:

newTbl:
load *,
field1 & '|' & field2 as %Compositekey
Resident Tbl;

[SaraAbdulah]

yes its five tables 

three of them need to connect them  with agent id