Forum Discussion

CLCastroEn's avatar
CLCastroEn
Icon for Helper IV rankHelper IV
5 years ago

how to relate two databases

Hello everyone! I am working with a database that has the following data: SKU, Store, Week, CLiente, , Category and Family. Where category and family are logically SKU hierarchies. The thing ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

CLCastroEn , maybe you try a composite key and try to make it one to many

example

key = [SKU] & " " & [Year]

  • CLCastroEn's avatar
    CLCastroEn
    Icon for Helper IV rankHelper IV
    5 years ago

    @amitchandak Hello! but anyway it would be several to several. because on both bases the SKU is repeated for different weeks, different customers.

    Maybe if I create a table with the composite key "SKU & Year & Customer" where there are only unique values? Some kind of bridge between the two bases and there if the one-to-many relationship would work?

    Best regards