I understand Like I said i know what I'm trying to do and what I am working with but it makes my head spin a bit. Yes I only have two tables The Blocks are defined by a 15 number unique Geo code the block groups have there own separate unique Geo code.

I just have been playing around with crystal reports and wonder if the insert sub report would work better. SO i guess as a side question if insert a sub report into a report then use it as a template will the sub report also change with the data. If it does I think that might be easier.

Table one is were 90 percent of my data is has everything from total population , race,  household type. And i may have misspoke it really isn't a geocode and more of a geo ID so I'm sorry about that, This process is a frying my brain. I guess I don't understand about this linking between the two tables they are completely separate from one another. to chose the ones I want I simply select the area that i want and ARCGIS has a wizard to make a access database and puts your selection into crystal reports. 

I do believe you are correct on the aspect of no real control over the joins. on a side note if there are columns with the same name in each table so if each table has a FID would that be the problem and its making a join for same name columns.

for the spreed sheet there is a lot of data within these tables so here is just a quick sample. Pretty much the rest of the data continues in the that fashion
Table One
FID,         GIS_CODE,         P008001_1,    P008002,   P008003,   P012001   
1     240910999911005            74                 65                3                 74
2     240910110022002            50                 33                6                 50
3     240910110034001            29                  7                 0                 29
4     240910110010909           104                55               14               104

Table 2
FID,         GISCODE,         SF3P008001,    P037001,   P037002,   P043001  
1       2409101101101            0                    0                  0                 0
2       2409101103309            204               102              12                66
3       2409101102502            501               139              99                29
4       2409101106609            74                 35                65               12