Forum Discussion

gautik92's avatar
gautik92
Regular Visitor
10 years ago
Solved

Cant Create Relationship

I want Date Field to be the relationship between tables  i dont have a primary key or unique field  how can i do that?
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi gautik92,

     

    According to your description, you want to create a relationship from two table with have the delicate data, right?

     

    If as I said, you can follow below methods:

     

    a. Use a temp table to link above tables’ column which has the dispute date.

     

    SalesRecords:

    StockIn:

    Customer:

     

    ‘SalesRecords’ and ‘stockIn’ contain ‘customer’, use customer to link two table.

    b. Search for a field which contain in two tables and has the unique data, use it to create the relationship.

     

    ‘SalesRecords’ and ‘stockIn’ contain ‘Date’ and it has unique data, use date to create relationship.

    c. Use LookupValue function to get the value currently.

     

    Lookupvalue(SalesRecords[Amount],SalesRecords[CustomerID],Values(StockIn[CustomerID]))

     

    Reference:

    lookupvalue function

     

    Regards,

    Xiaoxin Sheng

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

gautik92 You can simply create relationship between date fields from two tables provided field that you're creating relationship FROM doesn't have any duplicates.

gautik92's avatar
gautik92
Regular Visitor
10 years ago

Having Duplicate date fields

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi gautik92,

     

    According to your description, you want to create a relationship from two table with have the delicate data, right?

     

    If as I said, you can follow below methods:

     

    a. Use a temp table to link above tables’ column which has the dispute date.

     

    SalesRecords:

    StockIn:

    Customer:

     

    ‘SalesRecords’ and ‘stockIn’ contain ‘customer’, use customer to link two table.

    b. Search for a field which contain in two tables and has the unique data, use it to create the relationship.

     

    ‘SalesRecords’ and ‘stockIn’ contain ‘Date’ and it has unique data, use date to create relationship.

    c. Use LookupValue function to get the value currently.

     

    Lookupvalue(SalesRecords[Amount],SalesRecords[CustomerID],Values(StockIn[CustomerID]))

     

    Reference:

    lookupvalue function

     

    Regards,

    Xiaoxin Sheng