Master-Detail relationship with a secondary key

The current version of PHPRunner do not allow you to use more than one field to define Master-Details relationship.

OK, I have two tables:
Employee Table

Employee Dept

Employee ID

Employee Name

Etc...
Awards Table

Employee Dept

Employee ID

Award

Date of Award

Etc...
I want to browse the employee table, select an employee & then display a list of that employee's awards.

I need to match on both Employee ID & Employee Dept to retrieve the correct records.
Is there anyway I can achieve the same result?

Would changing the query help in any way?

I had the same problem and I solved through the creation of a VIEW in the database. Catch the two fields and create an only one to use in PHPRUNNER. See the example that I created: "..... select concat (`a`. ` COMPANY `, `a`. ` BRANCH `) AS ` ID `,..... ". That solves the problem, except for entrance of new registrations or alteration of those already existent.

I'm not sure I follow.

Do you mean create a "custom" view? Of both the master & detail tables?

Do I insert the "select" in the SQL query?

This view needs to be created in the database itself.

This view needs to be created in the database itself.

Thanks, I'll look at that.

MySQL server does not support this type of view.

Does anyone have another possible solution to offer? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=23199&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />

MySQL 5.0 does.
We'll have this feature in one of the following versions.