Skip to Content
0
Former Member
May 10, 2010 at 07:32 AM

F4 Help based on previous F4 value

32 Views

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?