How to change our forms to our business needs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have set up a form which enables us to log:
Date, Name (of employee), Batch no, Operation no, Qty (of product), minutes
(taken) and comments. The minutes are added up and the time it takes for
every single batch number is created automatically on Batch times. The
employee's work on several different projects every day and everytime we type
in an action, we have to type in the employee's name and date. We would like
to have a form where we go to the employee (every employee would have have
their own form), type the date once and all the actions would be listed.
Similarly to our old system, we would require the minutes of every batch no
to be on a separate form. However, we have no idea how to approach this? Can
anyone help please? Any suggestions welcome
 
Since I don't know how your database looks, I can't provide an exact answer,
but what I can tell you is you DO NOT want a form for each employee. That
would be a maintenance nightmare.

If your database structure is correctly implemented, the best solution would
be to have a form/subform. The form would allow you to select an employee
and date. The subform would contain the information for the batches and
operations. You would not have to reenter the employee info because it will
remain the same until you change it.
 
Back
Top