Re: WebDB Dynamic Linking
Date: 2000/04/26
Message-ID: <8e66ff$9j1$1_at_nnrp1.deja.com>#1/1
In article <3905F76D.6F80B288_at_gmu.edu>,
Jerre Hale <jhale_at_gmu.edu> wrote:
> Let me try this question again.
>
> Scenario: I have three forms and three reports. I am successful in
> linking individuals reports to individual forms, like report A to form
> A, report B to form B and report C to form C. I have also created a
> report that reports the data of all of the forms and linked it to one
> specific form but this is a generic form.
>
> I need to create a report that I can link back to the original form in
> which the data was inputted. Example; the report will generate
> Jobnumber, Jobname and other data. Jobnumber is a unique identifier
> that is included in all of the forms. So, if Jobnumber 1 has a
Jobname
> of A, I want to link to form A and display the data, if the Jobname
is
> B, I want to link to form B and display the data.
>
> As I said before, I can do this from specific report to specific form
> and also from all reports to a specific, generic form, but I cannot
come
> up with a solution to dynamically link to the original form and
display
> the data.
>
> Please respond, even if you do not have a solution. I need to know
that
> someone is really out there.
>
> Thanks,
>
> Jerre
>
>
Hi Jerre!
If you choose Report from SQL Query, you can build the link as you want.
Your SELECT could look like:
SELECT
'<A HREF="schema.form_jobname_' || Jobname ||
'.show?p_arg_names=_rowid&p_arg_values=' || Jobnumber || '">' ||
Jobname || '</A>' as "Job name",
...
FROM schema.table
WHERE ...
So for example, if Jobnumber 1 has a Jobname of A, you will get the
link to schema.form_jobname_A (in which don't forget to set the
Alternate ROWID to Jobnumber).
Regards,
Zdenek
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Apr 26 2000 - 00:00:00 CEST