changing parameter value at run time

[nadia]

hi
i have a problem and i need some help. i'm trying to change the value of a field at excution time ,the problem is that i have two queries without any link between them and i want to change data the second query due to the data in the first query.
with regards

[ahmadbilal]

please Elaborate your problem. are you facing this problem in oracle forms or oracle reports.

[nadia]

Thanks for your attention,
i'm facing this problem in oracle reports.

[ahmadbilal]

Please check lexical parameters to pass runtime value

[nadia]

i don't have porblem in lexical parameter.
my problem is like this:
in group1 i passed a lexical parameter but in group2 i have a tree with no data link to group1, for example group1 contains depts and group2 contains emps but there aren't any data link and i want to appear for each dept it's emps as a hirechytree

[ahmadbilal]

please post your exiting query.

Is there any primary foreign relation between emp and dept table if so then apply lexical parameters to pass parameters at runtime.
if you have no relation between these tables then noways to join this data.

[abdul_S]

did your problem resolved or not yet