Hi,
please see my answers below:
- Unfortunately you can't use complex foreign keys in PHPRunner. We'll add this feature in the next PHPRunner version.
- 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
