Skip to main content
Question

Many to Many relationship I think

  • November 6, 2023
  • 0 replies
  • 407 views
Forum|alt.badge.img+12

I have two tables.  One is a work record table and the other is a provider table.  I want to create a work record and pick the providers on the provider table that are associated with that work record.  There may be multiple work records that are associated to the same provider on the provider table.  How should I set this one up?



------------------------------
Carol Mcconnell
------------------------------

    MarceloBenavide
    Forum|alt.badge.img+8

    Hi, my sugestion for many to may is use a 3 tables.Look the diagram whit my proposal for best thinks and ideas.



    ------------------------------
    Marcelo Benavides
    ------------------------------



    ------------------------------
    Marcelo Benavides
    ------------------------------
    Terms & ConditionsAccessibility statement