This discussion is archived
1 Reply Latest reply: Dec 8, 2012 9:06 AM by Andreas Weiden RSS

Tab Data

951926 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points