i'm working on a database about employees and training programs that they need to go through before they go for on-field work. On employee form my boss wants that as soon as I enter Project # and employee Job Title, it automatically search from the other table the required trainings against the Project # and Job Title.
As I see, I need to check both fields on trigger On Lost Focus event whether they both are filled and then apply some kind of a query/macro to fill the Required Trainings field on the employee form.
How could I achieve that please??
Please avoid VBA because I don't understand it at these early stages, but I've started to understand Queries and Macros.
BTW: Can I use character string as a common field between two tables?? I don't feel a need of adding another field/ID just for the sake of relationship, plus my boss is not interested to enter an extra field in relationship table. I've Job Title column in common, that I could use for relationship in other table.
Thanks.
As I see, I need to check both fields on trigger On Lost Focus event whether they both are filled and then apply some kind of a query/macro to fill the Required Trainings field on the employee form.
How could I achieve that please??
Please avoid VBA because I don't understand it at these early stages, but I've started to understand Queries and Macros.
BTW: Can I use character string as a common field between two tables?? I don't feel a need of adding another field/ID just for the sake of relationship, plus my boss is not interested to enter an extra field in relationship table. I've Job Title column in common, that I could use for relationship in other table.
Thanks.
On Lost Focus
0 commentaires:
Enregistrer un commentaire