Hi,
I have two tables
empmaster
employee number ( Primary key )
emp name
empdetails
employee number ( foreign key)
Team_of_employee
date
hours_worked
There are 3 teams
Each team have around 5 employees
Screen Program
-
I have following details to enter data daily
Team :
Emp id :
date :
Hours_worked :
Hours worked will vary each day ....
It will be saved to the base table
My question
1.Search help should be enabled for team and employee in screeen
2.If i select team search help, the team description should be there
3.Then based on the team selection, the employees of that team only
should be showed if i click search help for employee
Then i will enter date and hours , that is not an issue
How to achieve this
tried to put values on domain value range for f4 help.. is this
ok?
how to put employee f4 based on the team f4?