Custom Listbox linked with another listbox

[#1]

Hi,

I ve a database which keeps the records of in & outs of the employees as date & time (in 1 column). These people can have 3 shifts namely 1,2 and 3.

I need to have 2 listbox where the 1st one keeps the date and 2nd one shifts.

When I choose 1 in the shift listbox, I want to have times from 00:00 to 08:00, for 2 08:00 to 16:00 and for 3 16:00 to 24:00.

My approach is the create 3 listbox;

1-) Custom listbox namely shifts with a data 1,2,3  (=ValueList('1','2','3'))

2-) Date & time table data with dates only ( I used =Date(Floor(TIME_RECEIVED)) function to keep the dates unique)

3-) Data & time table data with times only (This listbox does not need to appear in the form but not important)

How can I link shifts listbox with the times listbox?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Create a Shift field in the script:

Load

    floor(TIME_RECEIVED) as Date,

    frac(TIME_RECEIVED) as Time,

    ceil(frac(TIME_RECEIVED)*3) as Shift,

    ...other fields...

From ...mysource...;

Use the new Shift field for the listbox