New Auto Limited Record

[boyaqoub]

HI

im trying to make Daily LogBook to my Work,

i created the table and 2 Form for it,

i want 1 for that only viewing past record no editing,

and for the second i want it to be

Auto add new record from 6:00 am to 2:00 pm, and then auto save..

i want the form stay in for 8 hour,, even if you save it, it will not be in viewing form unit 2:00pm
"so it will be limited for workers to write every thing daring the 8 hours"

Please help me and thank you all

 

[boyaqoub]

for number 2, it's will be new record "last record"
for number 4, there will be no multiple entries to the same form,

the thing is i only want "limited record",

it's for Morning from 6:05am to 2:05pm
for afternoon from 2:05pm to 10:05pm
and for night from 10:05pm to 6:05am

every record will have time on it like "morning shift", "afternoon shift","night shift"

the code will be in load form.

If the date not = last record && last record = night shift && time between 6:05 to 2:05
Then create new record <<< It's will be Morning shift then,

 

[Mark_]

What business goal is accomplished by adding in ONE record for a given time period?

This type of "Auto added record" is normally seen when a system needs a "Parent" for all transactions in a shift and the developer is trying to find a handy place to store periodic totals.