Forum Discussion

Alex_Hasan's avatar
Alex_Hasan
Icon for Helper II rankHelper II
4 years ago

Making an active relationship between two tables where no relationship exists

In this two tables, there is no relationship (Only many to many relatioship can be formed). So, I want to make 1 to many relationship where the factsales will also contain customerkey (Many side)  Ho...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Alex_Hasan , In the customer table, the customer key should be unique and should not have a blank value. then you should be able to create a 1-M join

Alex_Hasan's avatar
Alex_Hasan
Icon for Helper II rankHelper II
4 years ago

Yes, customer key column is unique and does not have a blank value. But how to create a customer key column in factsales table?