I am making a trip log which will track the vehicle, driver, routes (or legs), passengers, which legs the passengers were on, etc.

What type of table relationship do I need for the passengers?  I would like the passengers to be selectable from a list, or be added if a new passenger.  I would like a selectable leg multiple choice that shows which leg each passenger was on.

I made a sub-table for passengers, but I cannot seem to select the passenger if they have already been entered.  Also, the leg data probably shouldn't go with the passenger, so where should I place it?

I'm not sure if this picture is readable or not.