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!
Oh yeah... it has to be deliverd before 09:00 CET tuesday the 27th of January