How do I link these tables. One is Project details and the other is Sales details. Both Excels have ProjectID and SaleID. Project Details is more on the Status values and Sales is about budget , forecast information.
1 - What should be the key to join the two tables
2 - is it ok if I comment the SaleID in the Sale Table and link both the PRoject and Sales Excel with ProjectID field
Please let me know if doing so by commenting would not cause any data issues . The link would be on the higher umbrella ProjectID. SaleID is a subset to each Project. Please let me know if it will work on commenting saleid in the second excel
3. do I need to build my key by using both these keys - don't know how to do that. can you please give me the syntax and explain.
is it necessary in this case - i.e. if I use the approach in 2, will it be correct.