Help me Plzzzzzzzz

[sougatau]

Say A shop has 15 branches in 4 cities.
In
City A - 5 Branches
City B - 3 Branches
City C - 6 Branches
City D - 1 Branch

Each branch has 10 employees and 1 Branch owner

Employee level
A1 and A2

> Payment System
City Employee type salary/day
A A1 20
A A2 25
B A1 20
B A2 30
C A1 25
C A2 50
D A1 30
D A2 35


Now I want to create a from where calculation of the employees will be done -like the below

We have to enter the branch code and 'month' for payment 1st.

Now the fileds wll appear
1.Employee id = (manual input)
2.employee name = (will appear automatically when I select employee id)
3.employee type= (will appear automatically when I select employee id)
4.salary/day = (will appear automatically when I select employee id)
5.no of days work =(manual input)
6.monthly payment=field 4 *field 5
7. bonus payment = field 6* 0.1 ( note instead of putting 0.1 here,I want to add the 'bonus' field in a table)

I also want to generate a report late
How can I do this? plz need a step by step guide

Hope these are understandable

I NEED HELP, I DON'T KNOW MUCH MORE ABOUT MS ACCESS

 

[sougatau]

no reply