Forum Discussion

21721's avatar
21721
Qrew Member
3 years ago

Table Structure with parent child relation

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
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------