Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Summary table

Hi. I am not sure how to name my problem correctly but here it is.  I have a production table that shows each production of employee per prod id then I also have an attendance table h...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Does column "ASP Id" (ID #1) also exist in Table "Roster"?

     

    I guess that you directly establish a relationship between "ASP Id" in  Table"UniqueASP_IDs" and "ID #2" in Table "Roster.

     

    You need to create another table column "ID #2" in  Table"UniqueASP_IDs".Then building  relationship between  the new column"ID #2" in  Table"UniqueASP_IDs" and "ID #2" in Table "Roster.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, Anonymous 

Does column "ASP Id" (ID #1) also exist in Table "Roster"?

 

I guess that you directly establish a relationship between "ASP Id" in  Table"UniqueASP_IDs" and "ID #2" in Table "Roster.

 

You need to create another table column "ID #2" in  Table"UniqueASP_IDs".Then building  relationship between  the new column"ID #2" in  Table"UniqueASP_IDs" and "ID #2" in Table "Roster.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.