Update a Record

[Guest]

I am getting ready to split my database so others can input information on
forms and others can use the queries, one problem I need answered.

My FE forms will be data entry "yes" so all of the past froms wont be
displayed. My problem is once a form has been started but not completed by
the first shift how can second shift get the same from up to complete it. All
employees use their pic codes to log onto company computers so when shift
changes different employee will finish the form because the work being done
may not be complete until some time on the second shift.

 

[Joseph Meehan]

I am getting ready to split my database so others can input information on
forms and others can use the queries, one problem I need answered.

My FE forms will be data entry "yes" so all of the past froms wont be
displayed. My problem is once a form has been started but not completed by
the first shift how can second shift get the same from up to complete it.
All
employees use their pic codes to log onto company computers so when shift
changes different employee will finish the form because the work being
done
may not be complete until some time on the second shift.

I am not at all sure what you are planning on doing.

Split database FE usually has the forms queries reports. The BE only
has the tables.

It seems you want one individual to start data entry on a FE and then
someone else (on the same PC or a different one?) to continue working on it.

Off hand I would suggest that each record have a unique ID and that the
first DEO (Data Entry Operator) either pass on their PC with out logging
off, to the second shift DEO or that they pass off that unique number along
with whatever other data the second shift DEO might need to continue the
work.

 

[Guest]

Each record has a unique Manifest Number (Primary Key "Yes, no duplicates)
that is entered on the forms first field. If I put the database out as data
entry can i have the unfinished form come up when the database is opened by
someone else if it is not completed, could the unfinished forms stay up until
a button to close or save that form is clicked, I want to make this as simple
as possible for the users.

 

[Joseph Meehan]

Each record has a unique Manifest Number (Primary Key "Yes, no duplicates)
that is entered on the forms first field. If I put the database out as
data
entry can i have the unfinished form come up when the database is opened
by
someone else if it is not completed, could the unfinished forms stay up
until
a button to close or save that form is clicked, I want to make this as
simple
as possible for the users.

How are you going to identify an "unfinished form" (I assume you mean
an incompletely filled out record, a form is just a box for displaying or
entering data that is then stored in a table or used in some way). Will the
"someone else" know there is unfinished work and will then be able to know
what additional data is needed?

 

[Guest]

Thanks for the check Joseph, I was trying to make thing more difficult than
they should be, I made a form so that the Criteria is set to [enter TicketID]
formatted for no record selector or navigation so that the user will just
have to enter the ticketid in the pop up box and then edit the rocord. Thanks
for the reply