Two Unrelated Tables and Have to Add together

[yamalady]

I have two unrelated tables. I have to combine them. I need to take one line from Table 1 and copy that line for each value in Table 2 AND add each value from Table 2.

For instance...If Table 1 looked like this:

Joe Smith Blonde Blue Eyes
Jane Smith Brunette Brown Eyes

And if Table 2 looked like this:
Fall
Winter
Summer
Spring



The final Table would need to look like this:

Joe Smith Blonde Blue Eyes Fall
Joe Smith Blonde Blue Eyes Winter
Joe Smith Blonde Blue Eyes Summer
Joe Smith Blonde Blue Eyes Spring
Jane Smith Brunette Brown Eyes Fall
Jane Smith Brunette Brown Eyes Winter
Jane Smith Brunette Brown Eyes Summer
Jane Smith Brunette Brown Eyes Spring


What is the easiest way to combine them in this manner?

[JoeM]

The easiest way is to create a query with these two tables and do not join the two tables.
If you create a query between two tables with no join/relationship set-up, Access will returns the Cartesian Product between the two (which means every row of one table will match up with every row of the other data, just like you want).

[yamalady]

Here I thought it would be more complicated than that! Over thinking things I guess. Awesome. That worked. Thanks JoeM.

[JoeM]

Your welcome!
Sometimes, its just knowing the little tricks!