Forum Discussion
brunozanoelo
Post Patron
Post PatronCompound key
Why i cant use Compound Key in the binding of the tables? Case: Company 1 Seller 5 Company 1 Seller 6 Company 2 Seller 5 Should o use one column like "First Pk"_"Second Pk"? 1_5 1_6 2_5...
Hi brunozanoelo ,
Compound keys are less essential in an Analytics/Reporting environment, but yes if you concatenate the values you can create relationships between tables.
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi brunozanoelo ,
Compound keys are less essential in an Analytics/Reporting environment, but yes if you concatenate the values you can create relationships between tables.
brunozanoeloPost Patron
Post PatronHi Phil_Seamark! Thanks a lot!
Have a great day!