How to set values which are searched from another table on the form.

[hiroyasutakeda]

Dear   ALL

I make the custom incident master table and form.The columns are as follow.

[insident master table columns]

    index(integer),

    title(string),

    caller(string),

        <etc.>

    site_code(Reference),  

    site_name(Reference),

    site_address(Reference)

And   I make a site master table too.The columns and sample records are as follow.

[site master table columns and sample records]

  site_code(integer)   |   site_name(String)                                 | site_address(string)                     ---> columns

  -----------------------------------------------------------------------------------------------------

  00001                                         |       ABC.com Tokyo, HQ                   |       Minato-ku, Tokyo                         ---> records

  00002                                         |     STU.com Osaka, Branch       |     Umeda, Osaka

  00003                                         |   XYZ.com     Nagoya,Branch   |   Nagoya,   Aichi

  When I make an incident record on the form, I would like to set values of site_cde, site_name and site_address referring to the   site master table.

  How should I set thse columns ("site_code","site_name" and "site_address")   of the insident   master table? Please tell me the way.

  I tried to set values using the workflow's   "Set Values" options, but I gave up. Because "Set Values" options   cannot set values searched from another table.

Best   Regards, Hiroyasu Takeda

[ruzzty06]

What is the purpose of your Incident master table? Shouldn't you be adding the Site Code, etc. to the Incident table itself? Then you can set the values using "Set Values".

Or if you will be using the Incident Master table for your Incidents then your workflow should be using that table, then you can also use "Set Values" to set the Site Code, etc.

[hiroyasutakeda]

Dear Rusty

    Thank you for your answer.

        >What is the purpose of your Incident master table?

        In our company, the staffs of the call center , engineers and field engineers   share the incident records. Filed engineers should know the site information of the customer. So we would like to include site information on the incident records.

Site code changes each time　we make an incident record , that is to say, site code is variable number not fixed value. So we cannot use "Set Values" option.I would like to look up   site_name, site_address from the site master table using key code "site_code".

(ex)

        >Select site_name, site_address from site_master_table

        >where   incident_master_table.sit_code = site_master_table.sit_code;

  We have many records of the site master table. Setting values of site code on the incident master tale each time is distant.

[Shishir Srivast]

on what basis are you going to decide the site code on new record on incident master table. you can do it through dot walking. For Example,   just like we can get other field details for caller,

[hiroyasutakeda]

Dear Shishir

  Thank you for your answer.

I set the column "site_code" of the incident master table like you said.

As a result, we can select the value refering to site master table   on   the incident form.

But I would like to set the values of these columns("site_name" and "site_address") on the incident form simultaneously.

[site master table columns and sample records]

  site_code(integer)   |   site_name(String)                                 | site_address(string)                     ---> columns

  -----------------------------------------------------------------------------------------------------

  00001                                         |       ABC.com Tokyo, HQ                   |       Minato-ku, Tokyo    

(ex.)

  If   I choose a value " 00001" as "site_code"   from the list on the incident form,

  I   hope that   the value "ABC.com Tokyo, HQ"   is assigned to   "site_name"   automatically.

Best Regards Hiroyasu Taeda