if i do report with parameter and this parameter had more than one field with list of value ,if the value in one field related with this value on other field
for example
in emp table in scott user
if i have two field one list of value for department_no
and other for employee_name
if the user select from the list of value one department the other field the employee in this department only appear in the list of value

you can type this select statment in the list of value (paramter form)
select emp_no,emp_name from emp order by emp_no

good luck

thank you for replay
but i need to do two field in one parameter with list of value
and put where condition to resrict the not need date in this list
for example
the first field with list of value(P_DEPARTMENT)
select dep_id,dep_name from dept order by dep_id(hiden first column)
the second field with list of value(P_EMPLOYEE)
select emp_name from emp where dept_id = _DEPARTMENT

it give me error because it not found the P_DEPARTMENT value
so how can put where condition from i get data from anther field

thank you for all,

i need any one answer to me plz i was sent this question from 7 days

استخدم فورم جديده .. جهز فيها ما تريد من شروط وعلاقات بين الاختيارات
ثم استدعى التقرير مباشرة للتنفيذ

مجرد فكرة

الاخ محمود
وضع جملة الاختيار بهذه الطريقة خطأ وأقترح عليك عمل الاتى :
select distinct E.dep_id,E.emp_name, D.dep_name from emp e, dept d
where e.dep_id=d.dep_id

thank you for all answer to me but no one can understand my question

ahmed tell me do the select with where cluase with condidtion
e.dep_id=d.dep_id
i need to put anther condition e.dep_id=(the value get from anther field in parameter)
thank you for all
plz i wait any one replay i need this for my job

i wait every body to answer my question

i wait every body to answer my question

67635[/snapback]

يا أخوان لا يمكن عمل ذلك فى الباراميتر فورم ويجب عمل فورم مستقلة تضع فيها الحول التى ترغب فيها ومنها تنادى الريبورت مباشرة

وانا كمان محتاج ااموضوع دا جدا