Hi guys i want to make fleet management program to cars in my organization but in erd diagram i face problem I have two table
I want to make design many to many relationship means one car can driven by many drivers and one driver can drive more cars.
My question how i represent this relation in database and interface (meaning are i make table to driver and table to car only in case that relation is many t many or what i do )
the third table that break relaton how i represent
suppose car and driver car_driver
how i represent car_driver in interface
are i make car_driver in form and car in form then driver in form when insert or what this actually my question