B
Basil
Hiya,
Can anyone suggest a way to do the following:
There are flights (airline) everyday of the year.
I need to set something maybe on an access form that will allow the crewing
people to record for everyday how many cabin crew were sick on the day (they
get the information off another system, but it is too ancient to even extract
data from - they have to copy and paste the data off the screen view!!).
There is also additional info that will need to be recorded daily in this way.
Can anybody guide me on using access for daily data - eg with a table that's
primary key is simply 'date' - (this would holds every date from whenever
until next year). Can it work neatly?
I was thinking eg 2 tables as such:
tblOperatedFlights:
Date_Operated (PrKey)
Flight_no (PrKey)
tblAbsenteeism:
Date (PrKey) 'Would hold all dates as stated above
Crew_Absent
Flight_Deck_Absent
Regarding recording the absenteeism, I was think - eg for Cabin Crew, that
there could be a calendar type of thing that actually holds fields linked to
the table within it - very similar to, say MS Outlook Calendar - where you
can enter data for each day, but it looks like a calendar rather than fields
and records.
Can anyone advise or lead me to a useful location??
Many thanks,
Basil
Can anyone suggest a way to do the following:
There are flights (airline) everyday of the year.
I need to set something maybe on an access form that will allow the crewing
people to record for everyday how many cabin crew were sick on the day (they
get the information off another system, but it is too ancient to even extract
data from - they have to copy and paste the data off the screen view!!).
There is also additional info that will need to be recorded daily in this way.
Can anybody guide me on using access for daily data - eg with a table that's
primary key is simply 'date' - (this would holds every date from whenever
until next year). Can it work neatly?
I was thinking eg 2 tables as such:
tblOperatedFlights:
Date_Operated (PrKey)
Flight_no (PrKey)
tblAbsenteeism:
Date (PrKey) 'Would hold all dates as stated above
Crew_Absent
Flight_Deck_Absent
Regarding recording the absenteeism, I was think - eg for Cabin Crew, that
there could be a calendar type of thing that actually holds fields linked to
the table within it - very similar to, say MS Outlook Calendar - where you
can enter data for each day, but it looks like a calendar rather than fields
and records.
Can anyone advise or lead me to a useful location??
Many thanks,
Basil