GSquared, thanks for the help. Here is the table structure. For simplicity I left out a lot of fields that aren't needed for the query and the foreign...