multiple key fields

Hi I just started using PHPRunner but had the same situation in the project I am working on.
look at the dependency option tutorial http://www.xlinesoft.com/tutorials/dependentdropdowns.htm

Tutorial
Meir

I know how dependant LOVs work.

In my situation first each combination of Values _A Values_B has to be unique. I dont know how to achieve this.

In an extra table a user selects from LOVs "Value_A" (not the keyfield) and "Value_B" (not the keyfield) and gets as result "Code". I dont know how to set this up. See sample below.
username, date, chosen Value_A, chosen Value_B, result code (read only)

Hi,
you can check entered values in the Before record added event and show error message if needed.

Here is a sample:

thanks, this works fine!
I can't get the second part of my question working

In an extra table a user selects from LOVs "Value_A" (not the keyfield) and "Value_B" (not the keyfield) and should get as result "Code". I dont know how to get the result field. See sample below.
username, date, chosen Value_A, chosen Value_B, result code (read only)

I prbalbly will have to put some cosde into after record added

Hi,
use this code in the Before record added event:

$values["Code"] = $values["Values_A"].$values["values_B"];

Thanx, the principle works, but I would like to obtain the values from TableC, while inputting data in table D

(table D: username, date, chosen Value_A, chosen Value_B, result code (read only))

desired workflow

user fills in table D ValueA and ValueB

with script: find in tableC the corresponding Values_A and Values_B and output the corresponding Code value in table D

Hi,
you need to select Code from TableC based on the Values_A and Values_C and save it in the TableD. Use Before record added event for this purpose.

the $data variable is not recognized

error 8, undefined variable data

Hi,
sorry for my fault.

Here is the correct one:

echo $values["Code"] gives the correct value but this value isnt filled in in the field,

do I need an extra command to accomplish this?

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

I uploaded to the demo account, at the demoaccount it works fine.

Looked into my mysql and corrected dataset types and lenght, it works now.

thanx!