master detail using frxado

maeve_zahra

dear all, i create master detail report using frxado. and i have query like this on detail query: select * from employeedetail where employeeno=:a

and i put parameter like this on query detail: a;string;<q1.employeeno>

q1.employeeno is field employeeno from master table.
i think that is correct because i use string as employeeno but i got this error message: argument are the wrong type.

i try change the parameter type to int also but still i got the same error.

please, anyone can help?

tia,
ryan

AlexTZ

To set master-detail relation, use the following sql:
select * from employeedetail where employeeno=:employeeno
and connect detail query to the master table via Master property. Master table should contain the field named "employeeno". Just like in Delphi...

maeve_zahra

AlexTZ wrote:

To set master-detail relation, use the following sql:
select * from employeedetail where employeeno=:employeeno
and connect detail query to the master table via Master property. Master table should contain the field named "employeeno". Just like in Delphi...

i try like you said and it work like a charm. thanks alot.