You have to create a form based on the table “tUren”. In the form it is ESSENTIAL that there are interdependent queries/fields. So what I mean is:
When filling in the form, the field “Medewerker-ID” from the table “tMedewerkers” is known.
So, in the form the following interdependent queries should work:
• Show only the “Klant-ID” who are related to this “Medewerker-ID”
• Show only the “Project-ID” who are related to the chosen “Klant-ID”
• Show only the “Activiteit-ID” who are related to the chosen “Project-ID”
Of course the entries have to be saved in the table “tUren”.
Furtermore it is important that the form shows the entries of that day (field “Datum” from the table “tUren”).
THAT’S IT! So you have only have to create one form with interdependent queries.
Payments in Escrow on GAF.
If you have any questions… don’t hesitate to contact me!
Kind regards.
I AM EMEM.
I HAVE EXPERIENCE IN MS ACCESS.
I AM ABLE TO CREATE QUERIES AND FORMS THAT ARE INTER-DEPENDENT.
I HAVE READ AND UNDERSTOOD YOUR PROJECT DETAILS.
I WILL FINISH AHEAD OF TIME.
LET ME DO IT FOR YOU.