I have three tables. Member, TrainingHistory and TrainingClass.
The Member layout have a portal listed training class taken.
The portal (TrainingHistory) has three fields, TrainingClass, fK_key, Member_No.
In find mode, how can I make a trick to display TrainingName
into fK_key field after selecting Training Class for users?
I know how to make a trick to display fK_Key field
showing TrainingClass using other field.
But I can not make in find mode.
I attached sample file
I need to help.
I'm not sure I fully understand what you want but
Assign a Hide Object value of 1 to Fk_key and do not check Apply in Find mode to only show in Find Mode and
Assign a Hide Object value of Get(WindowMode)=1 to Training Class and check Apply in Find Mode to hide in Find Mode.