Re: WebDB Dynamic Linking

From: Zdenek Zavadil <zzavadil_at_my-deja.com>
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

Original text of this message