1 Reply Latest reply: Dec 8, 2012 11:06 AM by Andreas Weiden RSS

    Tab Data

    951926
      Dear All,

      Master Form
      -----------------

      Employee Details
      -------------------------
      Employee_Id Name Job_Id Name
      1 Arun 1 Doctor
      2 Anil 1 Doctor
      3 Anzil 1 Doctor
      4 Rani 1 Doctor
      5 Nimul 2 Engineer
      6 Sanu 2 Engineer
      7 Vinu 2 Engineer
      8 Amol 2 Engineer
      9 Sonu 3 Clerck
      10 Manu 3 Clerck
      -----------------------------------------------------------


      I have two Tab in the Form

      They are,

      1.JOb_Details
      2.Salary_Details

      eg:-

      JOb_Details
      ------------
      JOb_ID Name Default Salary
      1 Doctor 10000
      2 Engineer 8000
      3 Clerck 5000


      Salary_Details
      ---------------

      Job_Id Name Employee_Id Name Salary
      1 Doctor 1 Arun 10000
      1 Doctor 2 Anil 10000
      1 Doctor 3 Anzil 10000
      1 Doctor 4 Rani 10000
      2 Engineer 5 Nimul 8000
      2 Engineer 6 Sanu 8000
      2 Engineer 7 Vinu 80000
      2 Engineer 8 Amol 80000
      3 Clerck 9 Sonu 5000
      3 Clerck 10 Manu 5000


      When I enter and save the 'JOb_Details' after Press The 'Salary_Details' then Salary Details will fill Based on Job from the 'JOb_Details'.


      eg:-

      JOb_Details
      ------------

      JOb_ID Name Default Salary
      1 Doctor 10000
      2 Engineer 8000


      when Press the 'Salary_Details' then will Fill the following details

      Salary_Details
      ---------------

      Job_Id Name Employee_Id Name Salary
      1 Doctor 1 Arun 10000
      1 Doctor 2 Anil 10000
      1 Doctor 3 Anzil 10000
      1 Doctor 4 Rani 10000
      2 Engineer 5 Nimul 8000
      2 Engineer 6 Sanu 8000
      2 Engineer 7 Vinu 80000
      2 Engineer 8 Amol 80000



      eg:-


      Here change the salary of Perticular Employee.

      change the salary of Employee_Id =2. New salary Salary =15000

      Salary_Details
      ---------------

      Job_Id Name Employee_Id Name Salary
      1 Doctor 1 Arun 10000
      1 Doctor 2 Anil 15000
      1 Doctor 3 Anzil 10000
      1 Doctor 4 Rani 10000
      2 Engineer 5 Nimul 8000
      2 Engineer 6 Sanu 8000
      2 Engineer 7 Vinu 80000
      2 Engineer 8 Amol 80000



      then saved the 'Salary_Details'

      Then go to 'JOb_Details' add one job
      eg:-

      Add JOb_ID =3

      JOb_Details
      ------------

      JOb_ID Name Default Salary
      1 Doctor 10000
      2 Engineer 8000
      3 Clerck 5000


      and Save the 'JOb_Details'


      then come to 'Salary_Details'

      the 'Salary_Details' Data Should be following data.



      Salary_Details
      ---------------

      Job_Id Name Employee_Id Name Salary
      1 Doctor 1 Arun 10000
      1 Doctor 2 Anil 15000
      1 Doctor 3 Anzil 10000
      1 Doctor 4 Rani 10000
      2 Engineer 5 Nimul 8000
      2 Engineer 6 Sanu 8000
      2 Engineer 7 Vinu 80000
      2 Engineer 8 Amol 80000
      3 Clerck 9 Sonu 5000
      3 Clerck 10 Manu 5000


      How to do this Task.Please give me one Solution.

      Thanks and Regards,
      Fazil

      Edited by: 948923 on Dec 8, 2012 3:02 AM
        • 1. Re: Tab Data
          Andreas Weiden
          What exactly is the problem? Do you want to fill the blocks automatically? If so, do you want to query existing data or do you want to create new records?

          In your example you say you change the salary for employee-id 2 to 15000, but in your example you show then employee-ids 1 and 2 with changed salary. Why?