How i represent relation many to many in interface(are every table represent by form)
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

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

Hybrid View

  1. #1
    Join Date
    Jan 2014
    Posts
    13

    Red face 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

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Wallisellen (ZH), Switzerland
    Posts
    17,358

    Re: How i represent relation many to many in interface(are every table represent by f

    Victor Nijegorodov

  3. #3
    Join Date
    Jan 2014
    Posts
    13

    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

  4. #4
    Arjay's Avatar
    Arjay is offline Moderator / MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    11,243

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center