How i represent relation many to many in interface(are every table represent by form)

[ahmedsa]

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 )
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

[VictorN]

See
http://en.wikipedia.org/wiki/Many-to-many_(data_model)
How to implement it in SQL Server database

[ahmedsa]

Thank you for reply
How i represent third table that break relation meaning if i have
driver table
car table
car_driver table I don't have any problem in database diagram .
My problem in interface How i represent it.
Are creating
driver form
car form
car_driver form
when inserting data

[Arjay]

Since you are using SQL and C#, check out Entity Framework

http://www.entityframeworktutorial.n...tionships.aspx