Hey!

Beginner programmer here. Making a journey planner to make paper bus timetables more accessible but seriously struggling.
The journey planner basically has

*a drop down menu with 5 options (FROM)
*another drop down menu with the same five options (TO)
*A calender for the date (that the person wants to travel)
*A space for a person to type in the journey time How will I create this journey planner to search for the nearest time entered in the box?)
*2 radio buttons under the journey time saying 'departing' or 'arriving'
*2 tick boxes (First bus of the day) and (last bus of the day)
(
2 radio buttons underneith that saying *departing at and *arriving at
I also have 2 tick boxes saying 'first bus of the day' and 'last bus of the day'

I'm trying to create the relationships but am not sure how to!I basically need to create relationships between the 'from' and 'to'
The journey date and time
The journey date and the last bus as well as first bus
The journey time and the radio buttons 'departing and arriving'

Any help would be appreciated!

also-:When trying to select a data type for a time such as 22:45 what would the data type be? Is it datetime..or smalldatetime or something else?