How i make many to many relationship in database and interfa

Question

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
Driver table
Diver No
Name
Address
Car No

Car table
Car No
Driver No
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 )

ahmed sa · Answer

Driver car mapping table how i represent it in interface(are i represent it by dropdowlist to car and dropdownlist to driver i need answer like this) please help me

ahmed sa · Answer

i don't understand how i will represent form in this d table DriverCarmapping table

ahmed sa · Answer

Thank you but please if possible What i mean is create driver form then create car form then create form to both or what

Jignesh Trivedi · Answer

hi Many to many relation between entities or table can be acheive by introducing the one table Like Driver table Diver No Name Address Car table Car No DriverCarMapping Table CarNo DriverNo hope this will help you.

Deepak Verma · Answer

Hi Ahmed I think it's a good idea to keep DriverNo and CarNo columns Primary Key in Driver Table and Car Table respectively. And create a third table with columns DriverNo and CarNo (both as Foreign Key).