I want to create a 'master date' dimension, so people pick one date and have all three tables zoomed on that one date.
I thought about concatenate the 3 qty table, but then realize it's bad for my overall data structure which i didn't show in the example below. After few rounds of trying, i realize creating 3 stand alone tbls for each qty is easiest and cleanest approach. I didn't have any syn keys in my actual application, i used product + site# as key, where description of product and site are stored in status table.
So now all i need is the ability for people for find the date they are looking for and update the selection across 3 tables.
