Forum Discussion
Creating relationships between multiple tables
i'm making some more progress with the query.... however, the table smpEP2 doesn't have a field called "RUN_TYPE".... so I tried to add one, by making a new column, and putting the label "EP2" in every row. When I append the query it is bringing in the EP1 data twice (once with blank RUN_TYPE labels), but not the EP2 values.
Similarly, I was trying to add a 6th table. I renamed some of the columns, and created a couple, so that they had similar column names and values to the others. When I append the query with this new table it isn't bringing it in at all..... when you append queries will it bring in all data with the same column headings into the table?
I've tried a few queries tutorials online, but not getting very far!
What you need is a lookup or bridge table. Add a date table with all dates (no skipped dates) and relate all of the other tables through one particular date such as your trade date. then populate your visuals using the date from the date table in the 'rows' and pull the values from the other tables. You can create lookup tables for many different granularities such as product, sales rep, store, and any other field that is consistent across the data.
Check out this link: