Forum Discussion
Creating relationships between multiple tables
TMQ,
Have you considered unioning the 5 tables into one? You will need to add another column to identify item (A, B, C,...). So your resultant table would have the columns
Date / Hour / Price / Item
You can do this in the "Edit Queries" window by using "Append Queries". There's even an option to do "Three or more tables" which would be helpful in this case.
Does that help?
~ Derek
I'll give that a try and let you know..... thanks!
No luck on the appending queries.... maybe the below picture will help explain. The five tables have similar (not exactly the same) data in the first three fields, and then I want to build reports analysing the remaining fields. When I tried to append the queries it brought it all together, but then I had an extra column with "null" in it.
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!
