Getting Started

 View Only
  • 1.  Table Structure with parent child relation

    Posted 06-16-2022 11:31
    Hi Team,
    I have created to table with one to many relationship.
    CMS as primary table Call Logs as child table. both tables contains Id.
    I want to join both tables by Id column.

    Example 
    CMS
    ID Name Age
    1001 Ram 30
    1002 Shyam 40
    1003 Kaka 50
    1004 Peter 60

    Call Logs
    ID Number Date
    1001 8800890220 16-06-2022
    1001 8800890220 16-06-2022
    1001 8800890220 16-06-2022
    1002 8800890221 16-06-2022
    1002 8800890221 16-06-2022
    1002 8800890221 16-06-2022

    I want to join both tables by Id Column.

    Regards,

    Raghvendra Mishra


  • 2.  RE: Table Structure with parent child relation

    Posted 06-16-2022 11:39
    Suggest that you change the key field of CMS table to be the [ID] field.  And you will be able to make your relationship easily.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------