2. PHPRunner General questions
  3. COMPOSITE PRIMARY KEY
This topic is locked

COMPOSITE PRIMARY KEY

 		6/17/2007 8:11:50 PM
PHPRunner General questions
J
 JColtro author

Hi.
My english is not so good.
1 - How build in PHPR a master-detail relationship if the master table was a COMPOSITE PRIMARY KEY (like: COMPANY; EMPLOYEE) and the child table was a composite foreign key with the same fields?
2 - How build in PHPR an multi-level login permissions system with MORE THAN two levels?
Tks.
J
 		Jane 6/18/2007

Hi,
please see my answers below:

  1. Unfortunately you can't use complex foreign keys in PHPRunner. We'll add this feature in the next PHPRunner version.
  2. To set up multi-level permissions open User group permissions dialog on the Security tab and create user groups on it.
J
 		JColtro author 6/18/2007

Hi,

please see my answers below:

  1. Unfortunately you can't use complex foreign keys in PHPRunner. We'll add this feature in the next PHPRunner version.
  2. To set up multi-level permissions open User group permissions dialog on the Security tab and create user groups on it.


Tks, Jane
About the 2nd topic, the situation is most complicated. My site was 3 (or more) levels: in the botton level, the login 'A Doe' must view the records of all the employees of the Sector A of Company A and the login 'B Doe' must view the records of all the emplyees of the Sector B of Company A; in the intermediate level, the login 'C Doe' must view the records of all employees of Company A...; in the top level, the login 'D Doe' must view all records of all companies.
About the 1st topic, it's really a good idea, because composite keys are very used in relational databases.
Tks again!
JColtro