Navigation:  Enhanced Crewing > Crew Database Layout. > Some Linking Examples > A Simple Accommodation Query

 

On the Example – For the crew boss, accommodation is required the day before and day of the shift

 

And they have been allocated to a hotel Room 1234

The following QBE shows the links to return the information.

Since Accommodation is linked to shifts The Activity date is the shift date and the Accommodation Day is the offset from the shift

From the Enumerated types or table definition we can see

   AccommodationDay Byte NOT NULL DESCRIPTION 'TAccommodationDay = (adBeforeShift, adOnShift, adAfterShift)', where enumerated types start counting at 0

So in this instance the Actual dates are The day before the shift (0) and the day of the Shift (1)