How i represent relation many to many in interface(are every table represent by form)
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
Re: How i represent relation many to many in interface(are every table represent by f
Re: How i represent relation many to many in interface(are every table represent by f
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
Re: How i represent relation many to many in interface(are every table represent by f
Since you are using SQL and C#, check out Entity Framework
http://www.entityframeworktutorial.n...tionships.aspx