This is actually probably a lot simpler then you think.
One way would be to create a list view based on your transaction table. And you just add any fields you want from both tables.
That means you can add the product field from the transaction table, but also the individuals name and city etc. from the first table.
If there are multiple purchases for a particular individual you will see their name appear multiple times, but that's no problem.
Now you can go into find mode and enter multiple values into multiple fields.
If you added the City field you can enter a city. And then in the product field you enter the product you want to search. For instance 'sweater'.
Hit perform find and you should get what you were looking for.
In this list view you can add all kinds of funky things like sub summary parts and global fields to help you more easily enter values to search on.
But that's all a little more advanced.
Thanks - that works for displaying the data - but what I would like to do is take the data selected and export it as a flat file to be imported into SPSS for data analysis.
You can just export this data.
File - Export Records.
You can export fields from different related tables at the same time.