I have 3 tables that I need to join and there's no unique column unfortunately. There are dates that are in common so I created a shell table that just has individual dates for a few years. Then I joined each table to that by date. Now, the issue I run into is identifying unique records from each table. I thought it would be something like. I want to create a calculated field that will Color+ID. Since the ID's overlap and so do the dates, the calculated field doesn't come out right.
How about Color+ID+Date as unique key?